题解 | #给表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name first from
(
select first_name,row_number()over() o,rank()over(order by first_name) f
from employees
)r
where f%2=1 order by o
投递牛客等公司10个岗位 >