我还以为测试用例错了, 当我看到 结果不要排序!!!
我悟了
select e.first_name from employees e join ( select first_name, rank() over (order by first_name) as tmp from employees order by tmp desc )t1 on e.first_name = t1.first_name where t1.tmp % 2 =1
select e.first_name from employees e join ( select first_name, rank() over (order by first_name) as tmp from employees order by tmp desc )t1 on e.first_name = t1.first_name where t1.tmp % 2 =1