title: How do I order my SQLITE database in descending order, for an android app?
body: <p>What is the most efficient method of showing my data in descending order?</p>
  
  <pre><code>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
  }
  </code></pre>