Skip to content

Instantly share code, notes, and snippets.

@anova

anova/mssql_row_number_over.sql

Created June 28, 2014 19:40
Show Gist options
  • Save anova/4074899bc4d8579e9144 to your computer and use it in GitHub Desktop.
Save anova/4074899bc4d8579e9144 to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL equivalent to MySql s LIMIT
Raw
mssql_row_number_over.sql
--Thanks to Muharrem Taç - http://www.muharremtac.com
SELECT *
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY UserId ASC) AS RNumber, *
FROM UserDetails
) AS [UserDetails] WHERE RNumber BETWEEN 100 AND 200
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment