OFFSET

Skips the first N rows of the result and is normally paired with LIMIT for paging, as in LIMIT 10 OFFSET 20. It is MySQL and PostgreSQL syntax; standard SQL uses FETCH FIRST n ROWS ONLY.

sql
SELECT title FROM film
ORDER BY title
LIMIT 10 OFFSET 20;

When to use

Not asked in the past papers or problem sets; it appears in Read 01. It runs at the end of the logical order, together with LIMIT.

See Read 01.

Appears in

No references yet.