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 vote186 views1 answer
Plsql while
SQL
0 vote186 views1 answer
Create date sql
SQL
6 votes241 views2 answers
Insert into select mysql
SQL
0 vote198 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote187 views1 answer
Oracle rolling back
SQL
0 vote197 views1 answer
Resulting Query
SQL
0 vote209 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote205 views1 answer
Create table database in psql
SQL
12 votes231 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote194 views1 answer
Add timestamp column to existing table ms sql server
SQL