我还以为测试用例错了,  当我看到 结果不要排序!!!
我悟了
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