# 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.

## 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

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