送上一段样例。 SELECT TOP 200 ROW_NUMBER() OVER(ORDER BY [name]) AS 'Row Number',* FROM Table1
想这样使用二次查询就可以使用到那个'Row Number'了。 select * from( SELECT ROW_NUMBER() OVER(ORDER BY [[name]) AS 'Row Number',* FROM Table1)a where [Row Number] >=5 and [Row Number]<10
SELECT TOP 200 ROW_NUMBER() OVER(ORDER BY [name]) AS 'Row Number',*
FROM Table1
select * from(
SELECT ROW_NUMBER() OVER(ORDER BY [[name]) AS 'Row Number',*
FROM Table1)a
where [Row Number] >=5 and [Row Number]<10