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 vote333 views1 answer
When mysql server would not work in xampp
SQL
0 vote347 views1 answer
Mssql unique key accept nulls
SQL
2 votes314 views1 answer
Drop table if exists in postgres
SQL
0 vote296 views1 answer
Create dabase postgresql
SQL
1 vote318 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote323 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote325 views1 answer
Sql describe
SQL
1 vote332 views1 answer
Operator does not exist: integer = text
SQL
0 vote329 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote314 views1 answer
Oracle rolling back transactions
SQL