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 votes183 views2 answers
Mysql first day of month
SQL
8 votes183 views1 answer
Unique vs primary key
SQL
0 vote190 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote176 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
1 vote176 views2 answers
Replace text in sql
SQL
0 vote197 views1 answer
Sql if clause within where clause
SQL
10 votes187 views4 answers
Drop primary key
SQL
0 vote191 views1 answer
How to get nth number in sql
SQL
0 vote172 views1 answer
Where case insensitive like mysql
SQL
10 votes191 views4 answers
Primary key in sql
SQL