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 votes308 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote305 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote287 views3 answers
Insert or ignore postgres
SQL
1 vote300 views3 answers
Connect to mysql c# connection string C#
SQL
8 votes297 views10 answers
Sql
SQL
11 votes284 views2 answers
Having in sql
SQL
0 vote284 views1 answer
Mysql order by where condition sub query
SQL
0 vote288 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote304 views1 answer
Closure in sql
SQL
0 vote286 views1 answer
Mysql preg replace
SQL