fazlurr
1/20/2015 - 7:56 AM

Android SQLite Database Query Method - http://stackoverflow.com/a/10601764

Android SQLite Database Query Method - http://stackoverflow.com/a/10601764

String queryString =
    "SELECT column1, (SELECT max(column1) FROM table1) AS max FROM table1 " +
    "WHERE column1 = ? OR column1 = ? ORDER BY column1";
    
sqLiteDatabase.rawQuery(queryString, whereArgs);
String[] tableColumns = new String[] {
    "column1",
    "(SELECT max(column1) FROM table2) AS max"
};

String whereClause = "column1 = ? OR column1 = ?";

String[] whereArgs = new String[] {
    "value1",
    "value2"
};

String orderBy = "column1";

Cursor c = sqLiteDatabase.query("table1", tableColumns, whereClause, whereArgs,
        null, null, orderBy);

// since we have a named column we can do
int idx = c.getColumnIndex("max");