瞎试出来的 select employees.first_name from employees join (select first_name from (select *,(rank()over(order by first_name))%2 ra from employees) as er where ra!=0) r on employees.first_name=r.first_name