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

User · Answer

We have one more option to do order by

public Cursor getlistbyrank(String rank) {
        try {
//This can be used
return db.`query("tablename", null, null, null, null, null, rank +"DESC",null );
OR
return db.rawQuery("SELECT * FROM table order by rank", null);
        } catch (SQLException sqle) {
            Log.e("Exception on query:-", "" + sqle.getMessage());
            return null;
        }
    }

You can use this two method for order

User · Answer

you can do it with this   Cursor cursor   database query              TABLE NAME              YOUR COLUMNS  null  null  null  null  COLUMN INTEREST   DESC

User · Answer

public List getExpensesList        SQLiteDatabase db   this getWritableDatabase         List lt String gt  expenses list   new ArrayList lt String gt         String selectQuery    SELECT   FROM     TABLE NAME        Cursor cursor   db rawQuery selectQuery  null       try          if  cursor moveToLast                   do                  String info   cursor getString cursor getColumnIndex KEY DESCRIPTION                    expenses list add info                while  cursor moveToPrevious                    finally          cursor close              return expenses list      This is my way of reading the record from database for list view in descending order  Move the cursor to last and move to previous record after each record is fetched  Hope this helps

User · Answer

Cursor c   scoreDb query Table Name  score  null  null  null  null  Column   DESC      Try this

User · Answer

According to docs   public Cursor query  String table  String   columns  String selection  String   selectionArgs  String groupBy  String having  String orderBy  String limit     and your ORDER BY param means      How to order the rows  formatted as an SQL ORDER BY clause    excluding the ORDER BY itself   Passing null will use the default   sort order  which may be unordered    So  your query will be    Cursor cursor   db query TABLE NAME  null  null              null  null  null  KEY ITEM     DESC   null

User · Answer

Cursor c   myDB rawQuery  SELECT distinct p name p price FROM products order by Id desc  new String         this works for me

User · Answer

SQLite ORDER BY clause is used to sort the data in an ascending or descending order  based on one or more columns   Cursor c   scoreDb query DATABASE TABLE  rank  null  null  null  null  yourColumn   DESC      SQLiteDatabase db   this getReadableDatabase        Cursor cursor   db query              TABLE NAME              rank              null              null              null              null              COLUMN     DESC               null

User · Answer

return database rawQuery  SELECT   FROM     DbHandler TABLE ORDER DETAIL                              ORDER BY   DbHandler KEY ORDER CREATED AT     DESC                             new String

User · Answer

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

User · Answer

This a terrible thing  It costs my a few hours  this is my table rows     private String USER ID    user id   private String REMEMBER UN    remember un   private String REMEMBER PWD    remember pwd   private String HEAD URL    head url   private String USER NAME    user name   private String USER PPU    user ppu   private String CURRENT TIME    current time    Cursor c   db rawQuery  SELECT   FROM     TABLE    ORDER BY     CURRENT TIME     DESC  null     Every time when I update the table   I will update the CURRENT TIME for sort  But I found that it is not work The result is not sorted what I want  Finally  I found that  the column  current time  is the default row of sqlite   The solution is  rename the column  cur time  instead of  current time

User · Answer

About efficient method  You can use CursorLoader  For example I included my action  And you must implement ContentProvider for your data base  https   developer android com reference android content ContentProvider html  If you implement this  you will call you data base very efficient   public class LoadEntitiesActionImp implements LoaderManager LoaderCallbacks lt Cursor gt        public interface OnLoadEntities          void onSuccessLoadEntities List lt Entities gt  entitiesList             private OnLoadEntities onLoadEntities       private final Context context       private final LoaderManager loaderManager       public LoadEntitiesActionImp Context context  LoaderManager loaderManager            this context   context          this loaderManager   loaderManager             public void setCallback OnLoadEntities onLoadEntities            this onLoadEntities   onLoadEntities             public void loadEntities             loaderManager initLoader LOADER ID  null  this               Override     public Loader lt Cursor gt  onCreateLoader int id  Bundle args            return new CursorLoader context  YOUR URI  null  YOUR SELECTION  YOUR ARGUMENTS FOR SELECTION  YOUR SORT ORDER               Override     public void onLoadFinished Loader lt Cursor gt  loader  Cursor cursor                Override     public void onLoaderReset Loader lt Cursor gt  loader

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

Examples related to android

Examples related to sqlite

Examples related to sql-order-by