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

11 votes149 views5 answers
Update table from another table mysql
SQL
0 vote113 views2 answers
Postgresql get long running queries
SQL
4 votes111 views4 answers
Date less than in sql
SQL
1 vote98 views2 answers
Mysql filter by date mount
SQL
3 votes110 views2 answers
Brew start mysql
SQL
0 vote120 views1 answer
Safe mysql
SQL
3 votes109 views2 answers
Truncate table
SQL
0 vote119 views1 answer
Check for directory in bash
SQL
0 vote114 views1 answer
Multiple tricky query in sql server
SQL
0 vote105 views1 answer
T-sql conditional order by multiple columns
SQL