题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select e.first_name from employees e where first_name in ( select first_name from ( select first_name, rank() over( order by first_name asc ) rk from employees ) a where a.rk % 2 = 1 )
投递虾皮信息等公司10个岗位 >