On this page 
Warning:
As of October 4, 2019, CockroachDB v2.0 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
INSERTorUPSERT. UPDATEandDELETEstatements.
Synopsis
LIMIT restricts the operation to only retrieve limit_val number of rows.
OFFSET restricts the operation to skip the first offset_value number of rows.
It is often used in conjunction with LIMIT to "paginate" through retrieved rows.
For PostgreSQL compatibility, CockroachDB also supports FETCH FIRST
limit_val ROWS ONLY and FETCH NEXT limit_val ROWS ONLY as aliases
for LIMIT. If limit_val is omitted, then one row is fetched.
Examples
For example uses with SELECT, see Limiting Row Count and
Pagination.
See Also
Was this helpful?
