How do I order my SQLITE database in descending order, for an android app?

by

Query has two syntax, the syntax you are using, last column represents orderBy, you just need to specify on what column you want to do orderBy +”ASC” (or) orderBy +”DESC”

Cursor c = scoreDb.query(DATABASE_TABLE, rank, null, null, null, null, yourColumn+" DESC");

Refer this documentation to understand more about query() method.

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Hindi font not displying correctly in android [closed]
  3. Unable to save and retrieve String data using Sqlite in android
  4. Share SQLite database between 2 android apps?
  5. Location of sqlite database on the device
  6. Android: upgrading DB version and adding new table
  7. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  8. Deleting Row in SQLite in Android
  9. How to disable the Clear Data button in Application info of Manage application
  10. How to convert image file data in a byte array to a Bitmap?
  11. Android sqlite how to check if a record exists
  12. Does Android Support JDBC
  13. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  14. How to perform an SQLite query within an Android application?
  15. SQLite Exception no such column when trying to select
  16. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  17. Android: column ‘_id’ does not exist
  18. How can I insert image in a sqlite database
  19. Android Cursor with ORMLite to use in CursorAdapter
  20. Is it possible to apply primary key on the text fields in android database
  21. What is The use of moveToFirst () in SQLite Cursors
  22. How to store sqlite database directly on sdcard
  23. sqlite example program in android [closed]
  24. How to check database on not rooted android device
  25. How to store JSON object in SQLite database
  26. sqlite3: not found
  27. Android SQLiteOpenHelper cannot open database file
  28. Getting the type of a column in SQLite
  29. Android table creation Failure (near “autoincrement”: syntax error)?
  30. sqlite insert into table select * from

Leave a Comment