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

2 votes282 views1 answer
Sql find missing values between two tables
SQL
0 vote301 views1 answer
Mysqldump ignore table
SQL
-1 vote325 views1 answer
Pl sql drop trigger
SQL
0 vote301 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote356 views1 answer
Mysql concatenate select results
SQL
5 votes313 views3 answers
Mysql remove unique constraint
SQL
1 vote323 views3 answers
Sql union
SQL
3 votes257 views1 answer
Postgresql where current year
SQL
0 vote283 views1 answer
Mql5 list all available symbols
SQL
1 vote328 views2 answers
Maximum number of tables in mysql
SQL