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;

原文地址:https://www.cnblogs.com/l10n/p/7523372.html