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 vote354 views1 answer
Reset postgresql password windows
SQL
0 vote344 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote352 views1 answer
Knex last insert id mysql
SQL
0 vote361 views1 answer
Install squirrel sql ubuntu
SQL
1 vote299 views1 answer
Prevent duplicate rows in postgres
SQL
5 votes357 views2 answers
Oracle rename table
SQL
1 vote357 views1 answer
How to check the mysql version mac
SQL
0 vote344 views1 answer
Oracle call a function in a insert statement
SQL
0 vote377 views1 answer
Convert excel into sqllite db using python
SQL
0 vote384 views1 answer
C# mysql data reader from two tables
SQL