# OFFSET

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: OFFSET
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-clauses/offset
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-clauses/offset.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-clauses/offset.adoc
description: The OFFSET clause skips a specified number of records from the result set.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-clauses/offset.md -->

The `OFFSET` clause skips a specified number of records from the result set.

## [](#syntax)Syntax

```sql
SELECT columns
FROM default_redpanda_catalog=>table_name
OFFSET num;
```

Where:

-   `columns`: The columns to fetch.

-   `table_name`: The table to fetch records from.

-   `num`: The number of records to skip.


## [](#examples)Examples

The following example uses a `salaryemp` table.

```sql
SELECT * FROM default_redpanda_catalog=>salaryemp ORDER BY emp_sal;
```

The query returns:

```sql
+-----------+------------+----------------+-------------+
| emp_id    | emp_name   | emp_div        | emp_sal     |
+-----------+------------+----------------+-------------+
| 1008      | Harry      | Operations     | 4500        |
| 1005      | Lewis      | Sales          | 5500        |
| 1002      | Mike       | Marketing      | 6000        |
| 1003      | Sean       | Marketing      | 6500        |
| 1009      | Steve      | Marketing      | 6800        |
| 1004      | Victor     | Finance        | 7000        |
| 1007      | Meghan     | Finance        | 7500        |
| 1006      | David      | Marketing      | 8000        |
| 1010      | Omar       | Finance        | 8000        |
| 1011      | David      | Sales          | 8200        |
+-----------+------------+----------------+-------------+
```

The following query skips the first three rows and returns the next five, ordered by salary:

```sql
SELECT * FROM default_redpanda_catalog=>salaryemp
ORDER BY emp_sal
LIMIT 5 OFFSET 3;
```

-   `OFFSET 3` skips the first three rows (`Harry`, `Lewis`, `Mike`).

-   `LIMIT 5` returns the next five rows.


The query returns:

```sql
+-----------+------------+----------------+-------------+
| emp_id    | emp_name   | emp_div        | emp_sal     |
+-----------+------------+----------------+-------------+
| 1003      | Sean       | Marketing      | 6500        |
| 1009      | Steve      | Marketing      | 6800        |
| 1004      | Victor     | Finance        | 7000        |
| 1007      | Meghan     | Finance        | 7500        |
| 1006      | David      | Marketing      | 8000        |
+-----------+------------+----------------+-------------+
```