取出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条之间的数据,大家有好的可以分享一下.
(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条之间的数据,大家有好的可以分享一下.
 
                    
                 
                
            
         
 浙公网安备 33010602011771号
浙公网安备 33010602011771号