题解 | 给出employees表中排名为奇数行的first_name
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first from (select first_name as first, rank() over( order by first_name) as r1 from employees order by emp_no) as p1 where not mod(r1,2)=0;
查看25道真题和解析