11.2 跳过表中n行

select x.ename
from (
select a.ename,
(select count(*)
from emp b
where b.ename <=a.ename) as rn
from emp a
) x
where mod(x.rn,2) =1;

posted @ 2017-09-14 22:03  屠魔的少年  阅读(163)  评论(0)    收藏  举报