给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
with t as(
select first_name,
rank() over(order by first_name) first_name_rank
from employees
order by emp_no
)
select first_name from t
where mod(first_name_rank,2)=1
查看1道真题和解析