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

1 vote289 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote266 views1 answer
Postgresql contains
SQL
5 votes247 views3 answers
Truncate function in sql oracle
SQL
0 vote256 views1 answer
Mysql page segment
SQL
0 vote283 views1 answer
Error code 1241 mysql
SQL
0 vote266 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote266 views1 answer
Sql select rows with different values in one column
SQL
0 vote286 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote297 views1 answer
Bitmap join index
SQL
2 votes275 views2 answers
Enable foreign key checks postgres
SQL