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