Databases · Junior · Question 62 of 75

What does `OFFSET 20 LIMIT 10` do?

1Returns rows 10 through 20
2Returns 20 rows, starting from row 10
✓Correct answer: Skips 20 rows and returns the next 10

Explanation

It's the simplest pagination. For deep pages it gets slow, because the database still reads and discards the skipped rows.

Further reading

PostgreSQL: LIMIT and OFFSET ↗

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.