题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name as first
from employees
where first_name in (
select first_name
from (
select first_name,
row_number() over(order by first_name) as rn
from employees
) as t
where rn % 2 = 1
);
查看12道真题和解析