题解 | employees表中为奇first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
需要注意不改变原表顺序，所以用原表连接现在的表
select
e.first_name
from
employees e
join
(
select
first_name
,row_number() over (order by first_name) as rk
from
employees
) a
on e.first_name = a.first_name
where a.rk%2=1
