今天刚刚看到，没有测试性能。
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50

本文地址：http://www.phprm.com/database/8f2a5767982228a0ab5929a18aed9969.html

转载随意，但请附上文章地址:-)