# OFFSET Clause

*noun*

say it: **“OF-set klawz”** **/ˈɒfsɛt klɔːz/**

The SQL part that skips a number of sorted rows, used with FETCH to get one page of results.

## What does **OFFSET Clause** do in a relational database?

**OFFSET Clause** — A clause skipping a specified number of ordered result rows.

```sql
UPDATE customer
SET status = 'inactive'
WHERE customer_id = 1;
```

## In a sentence

- “**OFFSET** 20 ROWS FETCH NEXT 20 ROWS ONLY gives the second page.”

Level: Apprentice · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/offset-clause
