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

3 votes230 views4 answers
Psql list tables in schema
SQL
1 vote196 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
2 votes191 views2 answers
Exec procedure pl sql
SQL
-2 votes200 views1 answer
Remove root password mysql
SQL
31 votes194 views3 answers
Sql count(*)
SQL
1 vote199 views1 answer
Mysql alter decimal precision
SQL
0 vote209 views1 answer
Sql sum show 0 result
SQL
10 votes251 views4 answers
Else if mysql
SQL
0 vote188 views1 answer
Do postgresql
SQL
6 votes257 views2 answers
Install psql mac
SQL