Mysql offset from bottom

SELECT id FROM table ORDER BY id DESC LIMIT 5

If you like to select entries 10,9,[8,7,6,5,4],.. try (3 start index, 5 row count)

SELECT id FROM table ORDER BY id DESC LIMIT 3,5
Or 1,2,3,[4,5,6,7,8],9,10

SELECT id FROM table ORDER BY id ASC LIMIT 4,5

Source: stackoverflow.com

Similar codes

0 vote239 views1 answer
Sqlite3 pragma foreign keys
SQL
1 vote190 views1 answer
Tsql find foreign key references
SQL
0 vote227 views1 answer
Sql query tags
SQL
0 vote199 views1 answer
How to find database collation in postgres
SQL
23 votes223 views6 answers
Create table sql
SQL
1 vote184 views1 answer
Right outer vs left outer join
SQL
6 votes186 views1 answer
Oracle pl sql source
SQL
11 votes320 views2 answers
Import mysql dump command line windows
SQL
0 vote177 views1 answer
Find usage of table in sql server
SQL
0 vote201 views2 answers
Nodejs mysql convert to plain object
SQL