题解 | #给出排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name from( select first_name ,row_number() over() rn /*记住原表每行顺序*/ ,rank() over(order by first_name) rk /*order by改变了原表顺序*/ from employees ) frr where rk mod 2 =1 order by rn /*按原表顺序排列*/
