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 vote83 views1 answer
Oracle string length
SQL
1 vote68 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote79 views1 answer
Postgresql if else endif
SQL
0 vote78 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote76 views1 answer
Check duplicate values plsql
SQL
0 vote75 views2 answers
Android sqlite query join
SQL
14 votes84 views3 answers
SQL trim
SQL
0 vote82 views1 answer
Plpgsql raise notice
SQL
0 vote65 views1 answer
Minecraft duping allowed servers
SQL
1 vote85 views1 answer
Oracle stop
SQL