sql server 2005之后使用(行范围m-n)
SELECT * FROM
(SELECT *,ROW_NUMBER() OVER(ORDER BY colName ASC) AS Num FROM tbName ) AS TempTable
WHERE Num BETWEEN m AND n
sql server 2005之后使用(行范围m-n)
SELECT * FROM
(SELECT *,ROW_NUMBER() OVER(ORDER BY colName ASC) AS Num FROM tbName ) AS TempTable
WHERE Num BETWEEN m AND n