题解 | 给出employees表中排名为奇数行的first_name

#按原序列，看排行里人家是按emp_No排序的
select first_name 
from employees
where first_name in (


select first_name
from 
(
select first_name , row_number()over(order by first_name) as rn
from employees
) t where rn%2 <>0
)