---
description: Skip rows in Basin SQL query results with OFFSET to retrieve a specific page.
title: Basin SQL supports OFFSET
image: https://developers.cloudflare.com/changelog/post/2026-10-21-basin-sql-offset/og.png?v=249aeb6f014e129b
---

[Skip to content](#main-content)

[View RSS feeds](https://developers.cloudflare.com/fundamentals/new-features/available-rss-feeds/) [ Subscribe to RSS](https://developers.cloudflare.com/changelog/rss/index.xml)

[Back to all posts](https://developers.cloudflare.com/changelog)

October 21, 2026

## Basin SQL supports OFFSET

[Basin SQL](https://developers.cloudflare.com/basin-sql/) [Basin](https://developers.cloudflare.com/basin/)

Copy as Markdown| [View as Markdown](https://developers.cloudflare.com/changelog/post/2026-10-21-basin-sql-offset/index.md)| [Agent setup](https://developers.cloudflare.com/agent-setup/)

[Basin SQL](https://developers.cloudflare.com/basin-sql/) is a serverless, distributed SQL engine for querying Apache Iceberg tables in Basin Catalog. It now supports `OFFSET`, which lets you skip a specified number of rows when retrieving query results.

Use `LIMIT` to set the page size and `OFFSET` to skip earlier rows. With a page size of 100, use `OFFSET 0` for the first page, `OFFSET 100` for the second, and increase the offset by 100 for each later page. Add `ORDER BY` on a unique column to keep the row order consistent.

For example, this query returns the second page of 100 rows:

```sql
SELECT sale_id, total_amount
FROM my_namespace.sales_data
ORDER BY sale_id
LIMIT 100 OFFSET 100
```

For syntax and examples, refer to the [OFFSET clause](https://developers.cloudflare.com/basin-sql/sql-reference/#offset-clause) in the Basin SQL reference.

```json
{"@context":"https://schema.org","@type":"BlogPosting","@id":"https://developers.cloudflare.com/changelog/post/2026-10-21-basin-sql-offset/#page","headline":"Basin SQL supports OFFSET","description":"Skip rows in Basin SQL query results with OFFSET to retrieve a specific page.","url":"https://developers.cloudflare.com/changelog/post/2026-10-21-basin-sql-offset/","inLanguage":"en","image":"https://developers.cloudflare.com/changelog/post/2026-10-21-basin-sql-offset/og.png?v=249aeb6f014e129b","dateModified":"2026-10-21","datePublished":"2026-10-21","publisher":{"@type":"Organization","name":"Cloudflare","description":"One platform for your apps, agents, and workforce. Build, secure, and scale without managing infrastructure","url":"https://www.cloudflare.com/","sameAs":["https://github.com/cloudflare","https://www.linkedin.com/company/cloudflare","https://x.com/cloudflare"],"logo":{"@type":"ImageObject","url":"https://developers.cloudflare.com/logo.svg"},"address":{"@type":"PostalAddress","streetAddress":"101 Townsend St","addressLocality":"San Francisco","addressRegion":"CA","postalCode":"94107","addressCountry":"US"},"contactPoint":[{"@type":"ContactPoint","contactType":"Customer Support","url":"https://support.cloudflare.com/","availableLanguage":["English"]},{"@type":"ContactPoint","contactType":"Sales","url":"https://www.cloudflare.com/contact/","availableLanguage":["English"]}]},"isPartOf":{"@type":"WebSite","@id":"https://developers.cloudflare.com/#website","name":"Cloudflare Docs","url":"https://developers.cloudflare.com/"}}
```