Fetch one page of rows.
Section: Read and filter rows
Paginate with LIMIT and OFFSET
sql
sql
SELECT id, email FROM users ORDER BY id LIMIT 20 OFFSET 40;Explanation
Works well for smaller datasets, though keyset pagination scales better for very large tables.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Read and filter rows