题解 | 每个部门薪资排名前两名员工
每个部门薪资排名前两名员工
https://www.nowcoder.com/practice/89329eadd4a64126b1cd326ea0b7eff7
WITH e AS (
SELECT
department,
employee_name,
salary,
RANK() OVER(PARTITION BY department ORDER BY salary DESC) AS s_rank
FROM employees
)
SELECT
department,
employee_name,
salary
FROM e
WHERE s_rank < 3
ORDER BY department, salary DESC
广电运通公司福利 349人发布
，我看是万人项目吧
查看7道真题和解析