SQL Pagination with LIMIT OFFSET

Example:

Page 1 (rows 1-10):
SELECT * FROM products
LIMIT 10 OFFSET 0

Page 2 (rows 11-20):
SELECT * FROM products
LIMIT 10 OFFSET 10

Page 3 (rows 21-30):
LIMIT 10 OFFSET 20

LIMIT: max rows to return. OFFSET: rows to skip. Formula: LIMIT = page_size, OFFSET = (page - 1) × page_size.

Try SQL Beautifier →

FAQs

Is OFFSET efficient for large datasets?

No! OFFSET scans skipped rows. For large datasets, use keyset pagination (WHERE id > last_id).