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.

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

Updated