Skip to content

Instantly share code, notes, and snippets.

@rosenfeld

rosenfeld/pagination.sql

Created September 28, 2012 18:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save rosenfeld/3801359 to your computer and use it in GitHub Desktop.
Save rosenfeld/3801359 to your computer and use it in GitHub Desktop.
Download ZIP
Pagination example with PostgreSQL
Raw
pagination.sql
select username, count(*) over() from user order by username limit 5 offset 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment