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 ;