select column1 from (select column1,rownum rw from tablename where rownum<500) where rw>100 或者 select * from (select * from tablename where rownum<500 minus select * from tablename where rownum<100 ) order by rownum desc
select columnname,row_number() r from tablename where r between 100 and 500 group by columnname
select colname from (select colname ,rownum rw from tablename) where rw> 100 and rw <500
加入一个伪列,不是真实存在,是个流水号,规定它在100到500之间就可以了。例如: select row_number() rownum, a.* from a where rownum between 100 and 500
参考下这个: select * from (select rownum no, id, name select student where rownum<=500) where no>=100
select column1 from
(select column1,rownum rw from tablename where rownum<500)
where rw>100
或者
select * from
(select * from tablename where rownum<500
minus
select * from tablename where rownum<100 )
order by rownum desc
from tablename
where r between 100 and 500
group by columnname
(select colname ,rownum rw from tablename)
where rw> 100 and rw <500
select row_number() rownum, a.*
from a
where rownum between 100 and 500
select * from (select rownum no, id, name select student where rownum<=500)
where no>=100