Deviopath › PostgreSQL

Page Two of the Catalog

Easy · Sorting

OFFSET n skips the first n rows. With LIMIT, it splits a result into pages: page 2 with 5 rows per page is LIMIT 5 OFFSET 5.

The catalog shows 5 products per page, sorted by id. Return the id and name of the products on page 2.

Next: Graded vs All Students