题解 | 61#对于employees表中，给出奇数行的first_name#
对于employees表中，给出奇数行的first_name
http://www.nowcoder.com/practice/e3cf1171f6cc426bac85fd4ffa786594
错误答案：
select first_name from (select first_name,rank() over(partition by emp_no order by first_name) rank from employees) t where t.rank%2=1
正确答案：因为不能对答案进行排序，感觉题目都没有说清楚，对这种题目很无语
select e.first_name
from employees e
join
(
select first_name,rank() over(order by first_name) as rk
from employees
) t
on e.first_name=t.first_name
where t.rk%2=1sql题 文章被收录于专栏
牛客网里面的sql题，把答案和思路写下来
