Need to show a SQLite query in descending order
You can write like this:
Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_NAME+"
WHERE "+STATUS+" = "+"'0'" + " ORDER BY id DESC LIMIT 10", null);
return cursor ;
Use following statement....
select * from YOUR_TABLE_NAME ORDER BY ID DESC;
You need to add an ORDER BY ID DESC
to your select statement.
ORDER BY