题解
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name first
from employees
where first_name in(
select rk.first_name
from (select first_name, row_number() over(order by first_name ) posn
from employees) rk
where rk.posn % 2 = 1
)
OPPO公司福利 1142人发布