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

6 votes307 views1 answer
What is where clause in sql
SQL
0 vote317 views1 answer
Sql select most frequent value in column
SQL
3 votes321 views2 answers
Tsql join multiple record in one string
SQL
2 votes316 views6 answers
In operator in sql
SQL
4 votes323 views3 answers
Employee name starting with in sql
SQL
5 votes306 views3 answers
Day of week postgresql
SQL
0 vote319 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote319 views1 answer
Sql tablo sp
SQL
-2 votes328 views4 answers
How to get max salary in each department in sql
SQL
7 votes319 views2 answers
Oracle foreign key reference table
SQL