OFFSET Clause

OFFSET Clause

Omits a specified number of rows from the beginning of the result set.

Syntax

OFFSET rows

Semantics

rows

specifies the number of result set rows to omit.

Notes

When both LIMIT and OFFSET are specified, specified number of rows are skipped before starting to count the rows to be returned.
When using OFFSET, use an ORDER BY clause. Otherwise the query returns an undefined subset of the result set.