View difference between Paste ID: ETuKNp4e and bh7MRiyv
SHOW: | | - or go back to the newest paste.
1-
Cursor results = db.rawQuery("SELECT MAX(" + TIME + ") AS MAXTIME, SELECT MIN("+ TIME+") AS MINTIME 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);