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 vote371 views1 answer
Sql query tags
SQL
27 votes363 views6 answers
Set password mysql
SQL
0 vote377 views1 answer
Mysql limit order by
SQL
0 vote334 views4 answers
Sql year
SQL
17 votes322 views2 answers
How to assign date field for table in mysql
SQL
0 vote347 views1 answer
Sql bild in function
SQL
0 vote352 views1 answer
Find invalid datetime field
SQL
0 vote348 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote354 views1 answer
Sub query in linq
SQL
3 votes354 views1 answer
MySQL DELETE JOIN
SQL