select e.first_name from employees e, (select e.first_name,row_number() over(order by e.first_name) num from employees e ) n where e.first_name=n.first_name and n.num%2=1
1.需要安原表输出,需要原表和 求出来的奇数表join和where都可以
2.奇数表通过窗口函数求出顺序
select e.first_name from employees e, (select e.first_name,row_number() over(order by e.first_name) num from employees e ) n where e.first_name=n.first_name and n.num%2=1