题解 | #给出表中排名为奇数的first_name#
给出employees表中排名为奇数行的first_name
https://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
瞎试出来的
select employees.first_name
from employees join
(select first_name
from (select *,(rank()over(order by first_name))%2 ra
from employees) as er
where ra!=0) r on employees.first_name=r.first_name
