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

4 votes267 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote267 views1 answer
Sql remove last 2 digit
SQL
7 votes229 views1 answer
Alter table add key sql
SQL
0 vote255 views1 answer
Insert or update cassandra
SQL
4 votes271 views3 answers
Copy table postgres
SQL
0 vote264 views1 answer
Get only structure database mysql
SQL
11 votes269 views3 answers
Change column name sql server management studio
SQL
0 vote259 views1 answer
Replace null value within column mysql
SQL
2 votes273 views1 answer
Add default sql server
SQL
0 vote261 views1 answer
Order by ip address sql
SQL