题解 | #获取每个部门中当前员工薪水最高的相关信息#
获取每个部门中当前员工薪水最高的相关信息
http://www.nowcoder.com/practice/4a052e3e1df5435880d4353eb18a91c6
SELECT t.dept_no AS dept_no, t.emp_no AS emp_no, t.salary AS maxSalary FROM ( SELECT a.emp_no, a.dept_no, b.salary, DENSE_RANK() OVER(PARTITION BY dept_no ORDER BY salary DESC) AS ranking FROM dept_emp AS a JOIN salaries AS b ON a.emp_no = b.emp_no WHERE b.to_date = "9999-01-01" ) AS t WHERE ranking = 1 ORDER BY t.dept_no
