题解 | #对于employees表中，给出奇数行的first_name#
对于employees表中，给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
select first_name
from (select first_name,rank()over(order by first_name)rk
from employees
order by emp_no) t
where rk%2 = 1;
投递科大讯飞等公司10个岗位 >