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 vote344 views1 answer
T-sql email validation
SQL
4 votes333 views4 answers
Oracle tablespace tables list
SQL
1 vote327 views4 answers
Alter schema sql
SQL
10 votes319 views2 answers
Sql merge statement
SQL
7 votes373 views2 answers
Sql remove duplicates based on column
SQL
0 vote320 views1 answer
Pl sql search in all packages
SQL
0 vote335 views1 answer
Sql developer search all packages for text
SQL
6 votes332 views2 answers
Drop foreign key
SQL
0 vote336 views1 answer
How to reset the database value in SQL server
SQL
0 vote321 views1 answer
How to get employee having maximum experience in mysql
SQL