今天剛剛看到，沒有測試性能。

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