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

1 vote61 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote121 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
6 votes104 views2 answers
Postgresql restore from dump
SQL
0 vote125 views1 answer
Connecting mySQL to STS
SQL
0 vote121 views1 answer
Mysql export data with a where clause
SQL
1 vote138 views1 answer
Oracle transaction rollback not working
SQL
2 votes117 views1 answer
Merge firstname and lastname in sql oracle
SQL
16 votes117 views3 answers
Order by sql query
SQL
8 votes102 views5 answers
Grant permission in postgres
SQL
0 vote104 views1 answer
Call object contructor and call methods of object
SQL