Skip to content

Instantly share code, notes, and snippets.

@wullemsb

wullemsb/SQL 2012 Pagination

Created January 18, 2013 19:18
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 wullemsb/4567477 to your computer and use it in GitHub Desktop.
Save wullemsb/4567477 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server 2012 Pagination
Raw
SQL 2012 Pagination
SELECT * FROM PRODUCTS
ORDER BY PRODUCTNAME
OFFSET 10 ROWS
FETCH NEXT 10 ROWS ONLY
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment