Breaking News: Grepper is joining You.com. Read the official announcement!

mysql offset from bottom

Long Leopard answered on June 21, 2021 Popularity 2/10 Helpfulness 1/10

answer mysql offset from bottom

mysql offset from bottom

Comment

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

Popularity 2/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: mysql offset sql

Link to this answer
Share Copy Link