题解
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
# 需要使用窗口函数来赋予排名
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
);
投递快手等公司7个岗位