Skip to content

Instantly share code, notes, and snippets.

@nasermirzaei89

nasermirzaei89/pagination.sql

Last active February 22, 2016 08:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nasermirzaei89/ae58118a785c083b68b5 to your computer and use it in GitHub Desktop.
Save nasermirzaei89/ae58118a785c083b68b5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pagination.sql
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY "order" ASC) AS row_number FROM myschema.mytable) AS foo WHERE row_number > 200 AND row_number <= 210
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment