取出11-25条之间的数据

select top 10 * from orders where orderid>
(select max(orderid) from orders where orderid in
 (select top 10 orderid from orders order by orderid))


select * from (select top 10 * from (select top 25 * from customers) as a order by a.customerid desc) as b order by b.customerid


取出数据库中11-25条之间的数据,大家有好的可以分享一下.

posted on 2006-11-21 13:32  无忧浪子  阅读(201)  评论(0)    收藏  举报

导航