oracle跳过表中的 n 行
select mod(rr,2), v.*
from (select rownum as rr,t.* from (select * from emp where sal is not null order by sal)t
where rownum <=10
)v where rr>2
and mod(rr,2)=1 ;

select mod(rr,2), v.*
from (select rownum as rr,t.* from (select * from emp where sal is not null order by sal)t
where rownum <=10
)v where rr>2
and mod(rr,2)=1 ;
