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

Question

What is the most efficient method of showing my data in descending order?

public String getRank() {      String[] rank = new String[]{ KEY_ROWID };     Cursor c = scoreDb.query(DATABASE_TABLE, rank, null, null, null, null, null);   //reading information from db.     String rankResult = "";      int iRow = c.getColumnIndex(KEY_ROWID); //Cursor looking for column setting equal to these ints.       for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {          //Move to first row - where cursor starts and moves to next row as long it is not after last row.         rankResult = rankResult + c.getString(iRow) + "\n";          //Returning value of row that it is currently on.     }     return rankResult;  //returning result }  public String getName() {      String[] name = new String[]{ KEY_NAME };     Cursor c = scoreDb.query(DATABASE_TABLE, name, null, null, null, null, null);   //reading information from db.     String nameResult = "";      int iRow1 = c.getColumnIndex(KEY_NAME); //Cursor looking for column setting equal to these ints.       for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {          //Move to first row - where cursor starts and moves to next row as long it is not after last row.         nameResult = nameResult + c.getString(iRow1) + "\n";          //Returning value of row that it is currently on.     }     return nameResult;  //returning result }  public String getScore() {      String[] score = new String[]{ KEY_SCORE };     Cursor c = scoreDb.query(DATABASE_TABLE, score, null, null, null,null, null);   //reading information from db.     String scoreResult = "";      int iRow2 = c.getColumnIndex(KEY_SCORE); //Cursor looking for column setting equal to these ints.       for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {          //Move to first row - where cursor starts and moves to next row as long it is not after last row.         scoreResult = scoreResult + c.getString(iRow2) + "\n";          //Returning value of row that it is currently on.     }     return scoreResult; //returning result } 

Answer 1

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.