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

5 votes206 views3 answers
MySql get fields of table
SQL
3 votes190 views1 answer
Sql several or
SQL
3 votes194 views1 answer
Sql is not like
SQL
3 votes183 views3 answers
Mysqldump: couldn
SQL
0 vote190 views1 answer
C# mysql update statement set value to null
SQL
8 votes213 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote207 views1 answer
Creating a simple notify in postgresql
SQL
1 vote191 views2 answers
Restart identity cascade
SQL
0 vote209 views2 answers
Py sqlite if entry exists
SQL
3 votes185 views1 answer
Get all elements sql
SQL