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 vote207 views1 answer
Update table sql multiple set
SQL
2 votes213 views1 answer
Wait delay in sql server
SQL
1 vote217 views1 answer
Create new table in SQL from old table with data
SQL
0 vote211 views1 answer
Prepared statement mysql java delete selected rows
SQL
2 votes205 views1 answer
Codeigniter print last sql query
SQL
3 votes212 views2 answers
How to start postgresql on windows
SQL
8 votes243 views2 answers
Update sql server from another table
SQL
15 votes225 views5 answers
Show tables in oracle
SQL
5 votes204 views3 answers
Truncate function in sql oracle
SQL
0 vote205 views1 answer
Composit key in sql
SQL