# Limiting Query Results

The `LIMIT` and `OFFSET` clauses restrict the operation of:

- A selection query, including when it occurs as part of `INSERT` or `UPSERT`.
- `UPDATE` and `DELETE` 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.

## See also

- `DELETE`
- `UPDATE`
- `INSERT`
- `UPSERT`
- Selection Queries