题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select a.first_name from (select emp_no,first_name, row_number() over(order by first_name)as ranking from employees)a where a.ranking%2 !=0 order by a.emp_no
表示偶数a.ranking%2 !=0
查看9道真题和解析
投递牛客等公司8个岗位 >
