题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select t.first_name as first
from (
select first_name,row_number() over (order by employees.first_name ) as rk
from employees
) as t
right join employees on t.first_name=employees.first_name
where rk%2=1
