View difference between Paste ID: bh7MRiyv and ySPsCpPY
SHOW: | | - or go back to the newest paste.
1-
Cursor results = db.rawQuery("SELECT MAX(" + TIME + "),SELECT MIN("+ TIME+") FROM " + TABLE_NAME + " WHERE " + ROUTE_NUMBER + " == " + routeNo, null);
1+
Cursor results = db.rawQuery("SELECT MAX(" + TIME + ") AS MAXTIME, SELECT MIN("+ TIME+") AS MINTIME FROM " + TABLE_NAME + " WHERE " + ROUTE_NUMBER + " == " + routeNo, null);