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 vote268 views1 answer
Pip install mysqlclient error
SQL
37 votes292 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
14 votes291 views5 answers
Sql oracle limit
SQL
0 vote305 views1 answer
Query builder doctrien return sql
SQL
1 vote309 views1 answer
Postgres left join
SQL
16 votes261 views2 answers
Gremove folder from git
SQL
0 vote272 views1 answer
Linked server delete openquery
SQL
0 vote306 views1 answer
Create table split string function in sql server
SQL
0 vote271 views1 answer
Replace multiple string in query sql
SQL
-1 vote270 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL