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 votes325 views2 answers
Mysql convert timestamp to date
SQL
0 vote269 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote295 views1 answer
Stored function in sql
SQL
5 votes278 views2 answers
Sql server check port number
SQL
0 vote292 views1 answer
Mysql export search results
SQL
0 vote268 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote286 views1 answer
Java sql connection
SQL
3 votes305 views1 answer
Sql case update
SQL
1 vote316 views1 answer
Oracle transaction rollback not working
SQL
0 vote244 views1 answer
FindAllBy
SQL