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

7 votes129 views1 answer
Append column sql
SQL
0 vote152 views1 answer
Command line mysql xampp
SQL
0 vote130 views1 answer
Sql date d'aujourd'hui
SQL
0 vote126 views1 answer
SQL server select to get sum of hours
SQL
0 vote133 views1 answer
Stored function in sql
SQL
0 vote138 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
1 vote88 views1 answer
Pagination sql
SQL
0 vote117 views1 answer
Lister les index d'une table oracle
SQL
0 vote199 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote135 views2 answers
Sql select inside select
SQL