CODE 如下:
SELECT *
FROM (select ROW_NUMBER() Over(order by TableName) as rowNum, *
from Sales.TableName) as tablename
where rowNum> 0 and rowNum<50
CODE 如下:
SELECT *
FROM (select ROW_NUMBER() Over(order by TableName) as rowNum, *
from Sales.TableName) as tablename
where rowNum> 0 and rowNum<50