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 vote337 views1 answer
With_for_update sqlalchemy
SQL
2 votes336 views1 answer
Mysql last 7 days including today
SQL
0 vote345 views1 answer
What is initial catalog in sql connection string
SQL
1 vote330 views1 answer
Sql where last 12 months
SQL
0 vote644 views1 answer
Power bi connect to postgresql
SQL
0 vote314 views4 answers
Sql year
SQL
0 vote337 views1 answer
Sqlite3 update select
SQL
0 vote306 views1 answer
Alter session set nls_language french
SQL
0 vote304 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
4 votes314 views1 answer
Oracle error compilation line
SQL