select * from (select t.*,rownum rn from bas_goods t) where rn >=10 and rn<20
select * from (select t.*,rownum rn from (select * from bas_goods) t where rownum<20) where rn>=10
select * from (select t.*,rownum rn from bas_goods t) where rn >=10 and rn<20
select * from (select t.*,rownum rn from (select * from bas_goods) t where rownum<20) where rn>=10