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

5 votes152 views2 answers
Create table
SQL
1 vote163 views1 answer
Mysql random limit 1
SQL
0 vote168 views1 answer
Insert set mysql
SQL
2 votes204 views1 answer
Select from array in psql
SQL
0 vote195 views1 answer
Pgadmin save data greyed out
SQL
3 votes178 views2 answers
Order by postgresql
SQL
11 votes214 views2 answers
Docker create postgres db
SQL
8 votes164 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote191 views1 answer
How do I insert a blob in SQL?
SQL
0 vote166 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL