题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name as first from ( select first_name ,emp_no, row_number() over(order by first_name ) as rn from employees ) t where rn%2 != 0 order by emp_no ;
