题解 | #对所有员工的薪水按照salary降序进行1-N的排名#
对所有员工的薪水按照salary降序进行1-N的排名
http://www.nowcoder.com/practice/b9068bfe5df74276bd015b9729eec4bf
select emp_no, salary,
dense_rank() over(order by salary desc) as rk
from salaries
where to_date = '9999-01-01'
order by salary desc, emp_no asc
终于懂最后一行了,同时有desc降序和asc升序时要每一个都区分标注好