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