SQL 2023 · Querying
Paginate results
Skip 20 rows and return the next 10. Large offsets get slow, so prefer keyset pagination.
SELECT * FROM posts ORDER BY id LIMIT 10 OFFSET 20;
Official SQL 2023 documentation
SQL 2023 · Querying
Skip 20 rows and return the next 10. Large offsets get slow, so prefer keyset pagination.
SELECT * FROM posts ORDER BY id LIMIT 10 OFFSET 20;
Official SQL 2023 documentation
Was this page helpful?