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 vote344 views1 answer
Hibernate with springboot mysql
SQL
0 vote354 views1 answer
Sql server select record with max id
SQL
0 vote329 views1 answer
Date diff sql
SQL
0 vote369 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote380 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote345 views1 answer
Sql try catch
SQL
0 vote285 views1 answer
Oracle last user logon
SQL
0 vote361 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote387 views10 answers
Sql statement checker corrector
SQL
0 vote355 views1 answer
Hoq to import database source
SQL