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-21 14:40:19Z

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);

if you want to select a number from a row then this is the most simplest way to do it
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

Simon Dorociak · Accepted Answer · 2012-06-21 14:03:06Z

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, 2012 at 14:03

Simon Dorociak

33.5k10 gold badges70 silver badges107 bronze badges

6 Comments

user1403653 Over a year ago

Cursor c = myDB.rawQuery("SELECT * FROM " + TableName + "LIMIT 1;", null); but this is not working

Simon Dorociak Over a year ago

You are missing space before limit. try to use offset yet.

Simon Dorociak Over a year ago

check this

user1403653 Over a year ago

i dont have tio specify buddy thats a problem

Simon Dorociak Over a year ago

so when you add LIMIT 1 OFFSET 30, it will select 31st row. you must specify which row you want to select...

|

Collectives™ on Stack Overflow

Find nth ROW in SQLiteDatabase in android

2 Answers 2

2 Comments

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Linked

Related