Skip to content

Instantly share code, notes, and snippets.

@liuxd

liuxd/limit.sql

Last active August 28, 2019 04:19
Show Gist options
  • Save liuxd/81426a9378b0dbf1957cd35eb7b94db9 to your computer and use it in GitHub Desktop.
Save liuxd/81426a9378b0dbf1957cd35eb7b94db9 to your computer and use it in GitHub Desktop.
Download ZIP
[Offset, Limit] #MSSQL
Raw
limit.sql
# offset and limit. The query must be ordered.
SELECT * FROM Person.Person ORDER BY PersonID OFFSET 100 ROWS FETCH NEXT 5 ROWS ONLY;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment