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

27 votes228 views4 answers
Get all tables with column name sql
SQL
4 votes244 views2 answers
Dbms output
SQL
6 votes227 views1 answer
To count number of rows in SQL table
SQL
0 vote239 views1 answer
SAP Return
SQL
0 vote223 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote227 views1 answer
Sql eliminare un record
SQL
1 vote291 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote228 views1 answer
Contact mysql column field
SQL
3 votes224 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote231 views1 answer
Oracle array
SQL