去前10条记录
select * from table where rownum <11
取中间记录
方法一:
select * from (select rownum id,* from table where 1=1 order by field ) where id > 11 and id < 21
方法二:
select * from (select rownum ,* from table where 1=1 and rownum<21 order by field )
minus
select * from (select rownum ,* from table where 1=1 and rownum>11 order by field )