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 vote178 views1 answer
Can we rollback in sql
SQL
0 vote214 views1 answer
Openquery update linked server
SQL
0 vote173 views1 answer
Insufficient memory to excute the sql query
SQL
17 votes178 views6 answers
Sql select distinct
SQL
7 votes172 views1 answer
Sql server convert string to date
SQL
0 vote178 views1 answer
Groupby error in mysql
SQL
7 votes178 views2 answers
Execute mysql file
SQL
0 vote211 views1 answer
Openquery join two tables
SQL
-1 vote171 views2 answers
On update cascade
SQL
0 vote216 views1 answer
Get null value in sql
SQL