题解 | #给出employees表中排名为奇数行的first_name#
给出employees表中排名为奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name
from employees
where employees.emp_no in
(select emp_no from (select emp_no, rank()over(order by first_name asc) posn from employees) as a
where a.posn%2=1)
from employees
where employees.emp_no in
(select emp_no from (select emp_no, rank()over(order by first_name asc) posn from employees) as a
where a.posn%2=1)