kgundula/MSSQL equivalent MySQL query with limit clause

Last active January 4, 2016 06:09

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kgundula/8579904.js"></script>
Save kgundula/8579904 to your computer and use it in GitHub Desktop.

Download ZIP

MSSQL equivalent MySQL query with limit clause

Raw

MSSQL equivalent MySQL query with limit clause


	SELECT * FROM
	(
	SELECT TOP 30 *, ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS rnum
	FROM table1
	) a
	WHERE rnum > 10

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment