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 vote277 views4 answers
Stored procedure sql
SQL
-1 vote260 views1 answer
Mysql select all columns and specific fields as
SQL
5 votes248 views1 answer
Update sql user password
SQL
0 vote224 views0 answer
SQL
0 vote267 views1 answer
Sql period overlap
SQL
0 vote279 views1 answer
Oracle sql developer closed connection
SQL
5 votes262 views2 answers
Oracle rename table
SQL
0 vote264 views1 answer
Sql remove non numeric characters
SQL
0 vote264 views1 answer
Jdbc sql connection string
SQL
0 vote275 views1 answer
Sintaxis SELECT sql
SQL