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 vote230 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote180 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
1 vote214 views1 answer
Get all db sizes in mysql server
SQL
2 votes214 views1 answer
Sql create database
SQL
0 vote213 views1 answer
Sql server beginning of month
SQL
0 vote222 views1 answer
Alter boolean column postgresql
SQL
1 vote216 views3 answers
How to update column name in psql
SQL
16 votes241 views6 answers
Mysql find duplicates in same table
SQL
0 vote233 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote174 views1 answer
Import csv to mysql
SQL