select * from( select OrderId, Freight, ROW_NUMBER() OVER(order by Freight) as row from Orders ) a where row between 20 and 30
select * from( select OrderId, Freight, ROW_NUMBER() OVER(order by Freight) as row from Orders ) a where row between 20 and 30
转载于:https://www.cnblogs.com/kubimiantiao/archive/2012/06/02/2531567.html