How to get Last record from Sqlite

Question

I have a one table question table and one ImageButton  Back   I need to get the last inserted record from the database after clicking on the Back    My row contains the following columns  question  optionA  optionB  optionC  optionD  and I need the data for use on my Activity  I create one method in database but it s not working     Here is code for reference    MySQLiteHelper java extract   public List lt ObjectiveWiseQuestion gt  getLastInsertQuestion            long index   0      List lt ObjectiveWiseQuestion gt LocwiseProfileList new ArrayList lt ObjectiveWiseQuestion gt         db   getReadableDatabase        Cursor cursor   db query               sqlite sequence               new String    seq                 name                   new String   TABLE QUESTION               null              null              null              null         if  cursor moveToFirst                  do               ObjectiveWiseQuestion owq  new ObjectiveWiseQuestion                 owq setQuestion cursor getString 2                owq setOptionA cursor getString 3                owq setOptionB cursor getString 4                owq setOptionC cursor getString 5                owq setOptionD cursor getString 6                owq setCorrectOption cursor getString 7                LocwiseProfileList add owq             while cursor moveToNext              db close               return LocwiseProfileList      OnClickListner from AddQuestionActivity java  imgBack setOnClickListener  new View OnClickListener                                  Override     public void onClick View v                 msg            emptyFormField             try               final List lt ObjectiveWiseQuestion gt  LocWiseProfile    db getLastInsertQuestion                        for  final ObjectiveWiseQuestion cn   LocWiseProfile                                   db new MySQLiteHelper getBaseContext                     db getWritableDatabase                    txtQuestion setText cn getQuestion                     txtOptionA setText cn getOptionA                     txtOptionB setText cn getOptionB                     txtOptionC setText cn getOptionC                     txtOptionD setText cn getOptionD                     txtCorrectOption setText cn getCorrectOption                     db close                            catch Exception e                e printStackTrace                                     Please give me some hint

User · Answer

in sqlite  there is a table called sqlite sequence  this table contains the table name and it s last id number  if the id is auto incremented    So  to get the last row in a table just put    Select   from TABLENAME where id  SELECT   from sqlite sequence where name   TABLENAME

User · Answer

Here s a simple example that simply returns the last line without need to sort anything from any column    SELECT   FROM TableName ORDER BY rowid DESC LIMIT 1

User · Answer

Also  if your table has no ID column  or sorting by id doesn t return you the last row  you can always use sqlite schema native  rowid  field  SELECT column  FROM table  WHERE rowid    SELECT MAX rowid  FROM table

User · Answer

The previous answers assume that there is an incrementing integer ID column  so MAX ID  gives the last row  But sometimes the keys are of text type  not ordered in a predictable way  So in order to take the last 1 or N rows   Nrows   we can follow a different approach   Select   From   TableName    LIMIT  Nrows  offset cast  SELECT count     FROM   TableName    AS INT -  Nrows

User · Answer

Another option is to use SQLites LAST VALUE   function in the following way   Given this table    -------- --------- -------    OBJECT    STATUS    TIME    -------- --------- -------                                 1         ON        100                                   1         OFF       102                                   1         ON        103                                   2         ON        101                                   2         OFF       102                                   2         ON        103                                   3         OFF       102                                   3         ON        103     -------- --------- -------    You can get the last status of every object with the following query  SELECT                                DISTINCT OBJECT              -- Only unique rows     LAST VALUE STATUS  OVER      -- The last value of the status column         PARTITION BY OBJECT      -- Taking into account rows with the same value in the object column         ORDER by time asc        --  Last  when sorting the rows of every object by the time column in ascending order         RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING    -- Take all rows in the patition       as lastStatus FROM     TABLE   The result would look like    -------- --------------    OBJECT    LAST STATUS    -------- --------------                              1         ON                                        2         ON                                        3         ON             -------- --------------

User · Answer

I wanted to maintain my table while pulling in one row that gives me the last value in a particular column in the table  I essentially was looking to replace the LAST   function in excel and this worked       Select column name FROM report WHERE rowid    select last insert rowid   from report

User · Answer

If you have already got the cursor  then this is how you may get the last record from cursor   cursor moveToPosition cursor getCount   - 1     then use cursor to read values

User · Answer

To get last record from your table      String selectQuery    SELECT    FROM      sqlite sequence    Cursor cursor   db rawQuery selectQuery  null     cursor moveToLast

User · Answer

I think it would be better if you use the method query from SQLiteDatabase class instead of the whole SQL string  which would be    Cursor cursor   sqLiteDatabase query TABLE  allColluns  null  null  null  null  ID    DESC    1      The last two parameters are ORDER BY and LIMIT   You can see more at  http   developer android com reference android database sqlite SQLiteDatabase html

User · Answer

I think the top answer is a bit verbose  just use this  SELECT   FROM table ORDER BY column DESC LIMIT 1

User · Answer

Try this   SELECT        FROM    TABLE     WHERE   ID    SELECT MAX ID   FROM TABLE     OR   you can also used following solution   SELECT   FROM tablename ORDER BY column DESC LIMIT 1

User · Answer

Suppose you are looking for last row of table dbstr TABNAME  into an INTEGER column named   ID   for example BaseColumns  ID   but could be anyother column you want   public int getLastId         int  id   0      SQLiteDatabase db   dbHelper getReadableDatabase        Cursor cursor   db query dbstr TABNAME  new String    BaseColumns  ID   null  null  null  null  null        if  cursor moveToLast               id   cursor getInt 0              cursor close        db close        return  id

User · Answer

Just simple  you can move with Cursor moveToLast    method provides to move to the last record  cursor moveToLast

[android] How to get Last record from Sqlite?

Examples related to android

Examples related to sqlite