Find nth ROW in SQLiteDatabase in android

Question

How can i find nth ROW from SQLiteDatabase in android, i want something like this SELECT * FROM Student WHERE rownum = 2; Here rownum is not a part of Table in my DB looks like

--------
Number
--------
123
456
789

So here i want to fetch row 456.

jaisonDavis · Accepted Answer · 2012-06-21T14:40:19.660

2

Cursor c=db.rawQuery("SELECT * FROM Student", null);
                c.moveToFirst();
                index=c.getColumnIndex("rownum");
                x=Integer.parseInt(c.getString(index));
                while(index!=-1) 
                {
                    if(x==456)//or n
                    {

                        //do something

                    }
                    else{

                        c.moveToNext();
                        index=c.getColumnIndex("rownum");
                        x=Integer.parseInt(c.getString(index));

                    }
                }

EDIT:

Cursor c=db.rawQuery("SELECT * FROM Student", null);
c.moveToPosition(2);

edited Jun 21 '12 at 14:40

answered Jun 21 '12 at 14:09

jaisonDavis

1,407
2
22
36

if you want to select a number from a row then this is the most simplest way to do it – jaisonDavis Jun 21 '12 at 14:23
buddy but i want to get data which is on 2nd row coz database may be get updated so `456` order will be change but i always want 2nd record – user1403653 Jun 21 '12 at 14:27

score 1 · Answer 2 · answered Jun 21 '12 at 14:03

1

You can try to add add LIMIT 1 and OFFSET <n> to the statement that you can execute like

Cursor c = db.rawQuery(SELECT_QUERY, null);

answered Jun 21 '12 at 14:03

Simon Dorociak

33,374
10
68
106

`Cursor c = myDB.rawQuery("SELECT * FROM " + TableName + "LIMIT 1;", null);` but this is not working – user1403653 Jun 21 '12 at 14:05
1

You are missing space before limit. try to use offset yet. – Simon Dorociak Jun 21 '12 at 14:06
[check this](http://stackoverflow.com/questions/3325515/sqlite-limit-offset-query-doubt) – Simon Dorociak Jun 21 '12 at 14:12
i dont have tio specify buddy thats a problem – user1403653 Jun 21 '12 at 14:40
so when you add LIMIT 1 OFFSET 30, it will select 31st row. you must specify which row you want to select... – Simon Dorociak Jun 21 '12 at 14:44
check [this](http://stackoverflow.com/questions/16568/how-to-select-the-nth-row-in-a-sql-database-table) yet for better understand. – Simon Dorociak Jun 21 '12 at 14:50

Find nth ROW in SQLiteDatabase in android

2 Answers2