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 vote145 views2 answers
Import .sql into postgres db command
SQL
0 vote159 views3 answers
Convert sql query to python pandas
SQL
0 vote154 views1 answer
Sql log file inof
SQL
123 votes352 views5 answers
Sql where contains
SQL
0 vote144 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote156 views1 answer
Codigo crear tablas sql server
SQL
0 vote143 views1 answer
Storing RGBA in mysql db
SQL
2 votes137 views1 answer
How to delete view in sql
SQL
5 votes153 views2 answers
Postgresql insert select
SQL
0 vote145 views4 answers
Best data type to represent money in mysql
SQL