Just saw it today, didn't test the performance.
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum<50
http://www.bkjia.com/PHPjc/630990.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630990.htmlTechArticleJust saw it today, no performance test. SELECT * FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, * from Sales.CreditCard) as table where rowNum 0 and rowNum50...