# 需要使用窗口函数来赋予排名 select first_name first from employees where first_name in ( select first_name from ( select first_name, row_number()over(order by first_name) rank_num from employees ) t1 where rank_num%2 <> 0 );