Retrieving last inserted 'n' rows from a table

Question

I want to retrieve last inserted 'n' number of rows from an SQLite table. I used the below query but I'm getting error, please help me to correct my query. If my query is wrong please suggest me a better query:

public Cursor readLastNDetails(int n)
{
    return this.data.rawQuery("SELECT TOP ("+n+") Name,Place,occupation,Date from  tb_Employee order by id DESC", null);
}

@DhawalSodha this is not i m looking for, i want to retrieve the last n records — Jesbin MJ, May 10 '13 at 07:15

score 2 · Accepted Answer · edited Feb 26 '14 at 04:11

2

Use following query,

"select Name,Place,occupation,Date 
 from  tb_Employee 
 order by id 
 desc limit"+ n

edited Feb 26 '14 at 04:11

Sushil

7,865
2
35
66

answered May 10 '13 at 08:37

Swati Sachdeva

253
2
11

score 1 · Answer 2 · answered May 10 '13 at 08:58

1

finally i got the answer

public Cursor readLastNYield(int n)
{
    return this.data.rawQuery("select BatchName,Yield,ActualYield,Date from tb_LabAssessment order by id DESC limit "+n, null);
}

answered May 10 '13 at 08:58

Jesbin MJ

3,049
6
22
27

Retrieving last inserted 'n' rows from a table

2 Answers2