Intermediate
SQL
Q80 / 100
What does the "OFFSET" clause do when combined with LIMIT, e.g. "LIMIT 10 OFFSET 20"?
Correct! Well done.
Incorrect.
The correct answer is B) Skips the first 20 rows, then returns the next 10 rows, commonly used for pagination
B
Correct Answer
Skips the first 20 rows, then returns the next 10 rows, commonly used for pagination
Explanation
OFFSET skips a specified number of rows before starting to return rows, and LIMIT caps how many are returned — together implementing pagination (e.g. page 3 of 10 results per page).
Progress
80/100