select x.ename
from (select a.ename,(select count(*)from emp bwhere b.ename <=a.ename) as rnfrom emp a) xwhere mod(x.rn,2) =1;本文共 188 字,大约阅读时间需要 1 分钟。
select x.ename
from (select a.ename,(select count(*)from emp bwhere b.ename <=a.ename) as rnfrom emp a) xwhere mod(x.rn,2) =1;转载于:https://www.cnblogs.com/liang545621/p/7523372.html