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 vote142 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote139 views1 answer
Search db for table name
SQL
0 vote150 views1 answer
Oracle change password expiration policy
SQL
1 vote141 views1 answer
Search for tables with name postgresql
SQL
40 votes200 views6 answers
Update table mysql
SQL
0 vote161 views1 answer
Mysql wsrep ls
SQL
1 vote136 views4 answers
Postgres extract date from timestamp
SQL
8 votes135 views5 answers
Alter table add column with default value
SQL
20 votes137 views4 answers
Sqlite create table if not exists
SQL
1 vote136 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL