摘要:
select * from user_stream tselect t2.* from (select rownum r,t1.* from youtable t1 where rownum<?) t2 where t2.r>?--小于最大的,大于最小的,就是你需要的条数如果你取40-50条之间的只需要小于50 大于40就OK了.select t2.* from (select rownum r,t1.* from user_stream t1 where rownum < 20) t2 where t2.r > 9 阅读全文