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 vote277 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote259 views1 answer
Add column in sql server ubuntu
SQL
2 votes279 views2 answers
Postgres trigger insert into another table
SQL
4 votes262 views4 answers
What is primary key
SQL
0 vote272 views2 answers
Oracle select
SQL
0 vote273 views1 answer
Convert polygon to text in mysql
SQL
0 vote272 views1 answer
Oracle cpu metric
SQL
0 vote266 views1 answer
Mysql count number of occurrences in a column
SQL
-1 vote265 views1 answer
Window functions in sql
SQL
0 vote318 views1 answer
Postgres rename database
SQL