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