Skip to content

Instantly share code, notes, and snippets.

@ignacio-chiazzo

ignacio-chiazzo/key_set_base_pagination.sql

Created February 23, 2020 07:03
Show Gist options
  • Save ignacio-chiazzo/4afac7a2b06c16020f243cbfeecaa54c to your computer and use it in GitHub Desktop.
Save ignacio-chiazzo/4afac7a2b06c16020f243cbfeecaa54c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
key_set_base_pagination.sql
SELECT *
FROM products
WHERE ID > <since_id_param>
ORDER BY ID ASC
LIMIT 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment