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 vote131 views1 answer
Html css mobile menu arrow dropdown
SQL
1 vote157 views1 answer
Drop colum oracle 18c
SQL
0 vote123 views1 answer
Sql roll up rows into columns
SQL
0 vote115 views3 answers
Remove folders from remote git
SQL
0 vote126 views1 answer
Max mysql
SQL
1 vote127 views1 answer
Md5 encryption for existing records
SQL
0 vote123 views1 answer
Renommer table sql
SQL
0 vote110 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote118 views2 answers
Functions with parameters SQL
SQL
0 vote122 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL