SQL SERVER 2005提供的分页查询支持
类别: 数据库教程 
今天刚刚看到，没有测试性能。
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50
- 上一篇: 建立MYSQL数据库
- 下一篇: 在SQL SERVER 2005中解决死锁
