27,579
社区成员
发帖
与我相关
我的任务
分享
select top(5) * from
(
select top((@i+1) * 5) O.OrderType,O.ShippingMethod, OA.* FROM Orders O ,OrderAddress OA
WHERE O.ORDERID =OA.OrderID AND O.OrderStatusID<690 AND IsHoldOn =0 AND OA.IsBillingAddress=0 AND O.IsDeleted=0
order by O.ORDERID asc
)
order by
O.ORDERID desc