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); |