题解 | #对所有员工的薪水按照salary降序排名#
对所有员工的薪水按照salary降序进行1-N的排名
https://www.nowcoder.com/practice/b9068bfe5df74276bd015b9729eec4bf
SELECT emp_no, salary, (select count(distinct s2.salary) from salaries s2 where s2.salary >= s1.salary) AS rank_num FROM salaries s1 ORDER BY salary DESC, emp_no ASC;
手搓rnkk函数
(select count(distinct s2.salary) from salaries s2 where s2.salary >= s1.salary)
这个子查询是精髓，查出了s1.emp_no对应的工资的排名，并且用distinct防止重复计数
投递快手等公司10个岗位
