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

5 votes132 views3 answers
Show indexes mysql
SQL
0 vote126 views1 answer
Sql server select furst day of current year
SQL
5 votes137 views1 answer
How to get all table names in sql query
SQL
19 votes112 views6 answers
Sql create table
SQL
0 vote111 views1 answer
Ffeathers express mysql application users login
SQL
0 vote125 views3 answers
Fetlife
SQL
-1 vote108 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote114 views1 answer
Sql query contains multiple ids
SQL
22 votes142 views4 answers
Mysql format date
SQL
1 vote113 views1 answer
Table valued functions in sql
SQL