题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
with ranked as( select first_name,row_number() over(order by first_name) as r from employees ) select r.first_name from employees e join ranked r using(first_name) where r.r%2 = 1
按原表顺序输出的方法：from 原表 join 临时表
科华数据工作强度 92人发布