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 vote177 views1 answer
Const pool = mysql.createpool()
SQL
0 vote181 views1 answer
Drop all procedures sql server
SQL
1 vote223 views1 answer
Sql comment header
SQL
5 votes163 views2 answers
Sql conn
SQL
0 vote168 views2 answers
Sqlite
SQL
0 vote222 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote182 views1 answer
Show table status command in mysql
SQL
13 votes229 views3 answers
Sql online code
SQL
0 vote176 views1 answer
Oracle archivemode
SQL
0 vote182 views1 answer
Difference between 2 query results sql server
SQL