Limiting Query Results

The LIMIT and OFFSET clauses restrict the operation of:

• A selection query, including when it occursas part of INSERT or UPSERT.
• UPDATE and DELETE statements.

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 aliasesfor LIMIT. If limit_val is omitted, then one row is fetched.

Examples

For example uses with SELECT, see Limiting Row Count andPagination.

See also

• DELETE
• UPDATE
• INSERT
• UPSERT
• Selection Queries

Was this page helpful?
YesNo