OFFSET

Applies to: sql

OFFSET skips a number of rows before returning results. It is common in pagination but can be slow for deep pages.

SELECT * FROM users
LIMIT 20 OFFSET 40;

See also: limit, order-by