---
schema_version: "1"
id: b262673ffe3a8aa3fae17e62c7cc1ae8267d4ab8fdb38657f98030847d9da166
title: OFFSET Clause
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-offset.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-offset.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: db73b051f0cdcd9c6de23fa50d902b028398f671e188d16524f7c23ec59e30a4
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# OFFSET Clause

By default, a SQL query retrieves every row in your dataset. Use the optional `WHERE` clause to restrict your query results to a conditional expression.

`OFFSET` takes the syntax `OFFSET {{start}}`. _Start_ refers to the number of rows to skip before returning rows.

This example skips over rows 1-5. It returns the three subsequent rows, 6-8.

```nolang
SELECT City
FROM "Superstore"
ORDER BY City
OFFSET 5
LIMIT 3;
```

| City     |
| -------- |
| Aberdeen |
| Abilene  |
| Abilene  |