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

19 votes196 views6 answers
Sql drop table if exists
SQL
0 vote188 views1 answer
Inserting data into different tables at once in oracle sql
SQL
1 vote186 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote188 views1 answer
Soql more than today
SQL
0 vote216 views1 answer
Synapse sql table set pk
SQL
0 vote193 views1 answer
Drop column from local database postgres pgadmin
SQL
19 votes192 views2 answers
Mysql tinyint max value
SQL
5 votes194 views3 answers
Oracle first day of last year
SQL
8 votes186 views3 answers
Alter table auto_increment
SQL
13 votes266 views4 answers
Mysql remove foreign key constraint
SQL