How to get Last 5 inserted/modified rows in sqlite

Question

I have a very basic database and my requirement is that whenever the app comesup it should show latest n additions (rows added) in the database. Additions should also cover replacing values in existing rows..

Think of a console where you are showing lastest 100 modifications to the DB.

To keep the size of db small I am not including a timestamp.

Is there anyeasy way to do it

http://stackoverflow.com/questions/311054/how-do-i-select-last-5-rows-in-a-table-without-sorting — Raghunandan, Jun 20 '13 at 07:27
He needs to be more specific about his definition of 'last'. The duplicate-link is also ambiguous about 'last'. If they both mean 'the bottom 5 rows' then it's a dup, but remember that SQL doesn't have to insert them in any order so the most recent rows could be at the bottom of the table. — Kelly S. French, Jun 20 '13 at 16:58
I have editied the question. So it should now not seen as dup — , Jun 21 '13 at 03:26
This question should not be seen as duplicate anymore, here the @mSO wants to know the last 5 inserted/modified rows in the table, not the last 5 rows that are present in the table. The question given in the link for duplicate doesn't even make sense, logically speaking isn't sql a storage without order? — Bhargav, Dec 10 '15 at 14:36

score 1 · Answer 1 · edited Apr 12 '14 at 07:52

1

Try Like:

String query= "SELECT * FROM table ORDER BY id DESC LIMIT 5";

edited Apr 12 '14 at 07:52

Pratik Butani

60,504
58
273
437

answered Jun 20 '13 at 07:46

Zulfiqar Chandio

263
2
7

score 0 · Answer 2 · edited Apr 12 '14 at 07:52

0

Try Like This:

String query = "SELECT * FROM table_name LIMIT 0,5";

edited Apr 12 '14 at 07:52

Pratik Butani

60,504
58
273
437

answered Jun 20 '13 at 07:53

Vaibs

1,128
3
16
36

score 0 · Answer 3 · answered Jun 20 '13 at 08:43

0

SELECT ROWID,* FROM [table] ORDER BY ROWID DESC LIMIT 5

answered Jun 20 '13 at 08:43

mihail

2,173
19
31

How to get updates in existing rows – Jun 21 '13 at 03:26
if you need to get the last 5 updated rows, you will need to include a timestamp field and update it on every modification on this row. – mihail Jun 23 '13 at 22:02
I see this for first time - unaccepted answer because of changing the topic of the whole question – mihail Jun 24 '13 at 09:30
oops my bad. I didnt used correct terms – Jun 24 '13 at 14:47

How to get Last 5 inserted/modified rows in sqlite

3 Answers3