how to display list in descending order using query() in stead of rawQuery()? android

Question

I try to user the following code to display my list in a descending order order by KEY_TIME, but it doesn't work, I tried rawQuery as well, but the program dead after I run it, please help me find the mistake, thanks!

   return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_TITLE,
    KEY_BODY, KEY_TIME, KEY_CATEGORY, KEY_ALARM}, null, null,null,KEY_TIME+"DESC",null);

Answer 1

Try this code,

return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_TITLE,
        KEY_BODY, KEY_TIME, KEY_CATEGORY, KEY_ALARM}, null, null,null,null,KEY_TIME+" DESC");