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 votes171 views2 answers
Postgres concat
SQL
2 votes157 views1 answer
Mysql Incorrect column specifier for column
SQL
5 votes260 views2 answers
Mysql date greater than 30 days
SQL
10 votes154 views4 answers
Sql pagination
SQL
4 votes151 views1 answer
Psql get sequences
SQL
0 vote150 views1 answer
10000000000000000000 am to meters
SQL
0 vote224 views1 answer
How to add auto increment primary key
SQL
2 votes185 views1 answer
Postgresql transaction
SQL
2 votes158 views1 answer
Oracle index size
SQL
0 vote172 views1 answer
Add column in sql server ubuntu
SQL