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 vote179 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote183 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
5 votes156 views1 answer
Mysql get last day of month
SQL
0 vote210 views1 answer
Drop table BigQuery table columns
SQL
8 votes193 views1 answer
Mysql dump restore
SQL
0 vote179 views1 answer
How to check which table has data in mysql
SQL
0 vote175 views2 answers
Sql server set default value equal to auto increment
SQL
4 votes168 views3 answers
Drop Table Oracle
SQL
7 votes174 views2 answers
Sql empty table
SQL
0 vote193 views1 answer
Sql datum formatieren
SQL