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 ;

 

 

posted @ 2018-05-10 13:54  wupf  阅读(328)  评论(0编辑  收藏  举报