SQL Server 2005 提供的分页查询支持

1/18/2006来源:SQL技巧人气:19710

今天刚刚看到,没有测试性能。

SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50