select * from ( select a.*,rownum rn from a) where rn>=21 and rn<=20
select * from ( select a.*,rownum rn from a where rownum<=30 ) where rn>=21
select * from (select * from table order by 排序的字段名) where rownum between 21 and 30
1:select * from (select a.*,rownum rn from logan.table123 a) where rn>20 and rn<32;2:select * from (select a.*,rownum rn from logan.table123 a) where rn between 20 and rn31;
1: select * from(select a.*,rownum rn from logan.table123 a)where rn>20 and rn<32;2: select * from(select a.*,rownum rn from logan.table123 a)where rn between 21 and 31;
from
(
select a.*,rownum rn
from a)
where rn>=21 and rn<=20
from
(
select a.*,rownum rn
from a
where rownum<=30
)
where rn>=21
1: select * from(select a.*,rownum rn from logan.table123 a)where rn>20 and rn<32;2: select * from(select a.*,rownum rn from logan.table123 a)where rn between 21 and 31;