On this page
Warning:
As of May 12, 2021, CockroachDB v19.2 is no longer supported. For more details, refer to the Release Support Policy.
The LIMIT
and OFFSET
clauses restrict the operation of:
- A selection query, including when it occurs as part of
INSERT
orUPSERT
. UPDATE
andDELETE
statements.
OFFSET
instructs the operation to skip a specified number of rows. It is often used in conjunction with LIMIT
to "paginate" through retrieved rows.
Warning:
Using LIMIT
/OFFSET
to implement pagination can be very slow for large tables. We recommend using keyset pagination instead.
Syntax
LIMIT
LIMIT { <limit_value> | ALL }
For PostgreSQL compatibility, CockroachDB also supports FETCH FIRST limit_value ROWS ONLY
and FETCH NEXT limit_value ROWS ONLY
as aliases for LIMIT
. If limit_value
is omitted, then one row is fetched.
OFFSET
OFFSET <offset_value> [ ROW | ROWS ]
Examples
For example uses with SELECT
, see Limiting Row Count and Pagination.