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 vote117 views1 answer
To change the database owner in SQL server
SQL
0 vote130 views1 answer
Insert or update sql firebird
SQL
0 vote117 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
34 votes140 views6 answers
Install mysql client ubuntu
SQL
1 vote126 views2 answers
Mysql limit offset
SQL
0 vote109 views2 answers
Mysql regexp match word
SQL
0 vote114 views1 answer
Postgres float to int
SQL
1 vote123 views1 answer
Select 2 rows in sql
SQL
0 vote141 views1 answer
Postgres full text search example
SQL
0 vote172 views1 answer
Scheduled mysql database backup in linux
SQL