题解 | #给出employees表中排名为奇数行
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select a.first_name
from employees a
inner join(
select b.first_name, row_number() over(order by b.first_name asc) rank_number
from employees b
) b
on a.first_name = b.first_name
where rank_number & 1
查看18道真题和解析
