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 vote204 views1 answer
Join to find results not in another table
SQL
0 vote189 views1 answer
How to update random rows in sql
SQL
0 vote212 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote207 views1 answer
Reset keys in sql
SQL
2 votes217 views2 answers
Mysql write into table
SQL
0 vote206 views1 answer
Copy row from db to db mysql
SQL
1 vote165 views1 answer
Alter user mysql native password
SQL
3 votes205 views2 answers
Oracle apex charging debug
SQL
4 votes209 views4 answers
Oracle tablespace tables list
SQL
20 votes195 views1 answer
Sql change column types
SQL