kgundula · January 4, 2016 06:09
diff --git a/MSSQL equivalent MySQL query with limit clause b/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

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