use dense_rank() and inner join
\nSELECT Department, Employee, Salary\nFROM (SELECT D.Name AS Department, E.Name AS Employee, E.Salary AS Salary , DENSE_RANK() OVER(PARTITION BY E.DepartmentId
```\nSELECT Department, Employee, Salary\nFROM (SELECT D.Name AS Department, E.Name AS Employee, E.Salary AS Salary , DENSE_RANK() OVER(PARTITION BY E.DepartmentId ORDER BY E.Salary DESC) RN\n     FROM Employee E\n     INNER JOIN Department D\n     ON E.DepartmentId = D.Id)\nWHERE RN=1\n```\n\u4E00\u5F00\u59CB\u60F3\u7528group by\u6765\u7740\uFF0C\u53D1\u73B0\u5206\u7EC4\u7684\u65F6\u5019\u8981\u4E48\u8003\u8651\u5B50\u67E5\u8BE2\u8981\u4E48\u4E0D\u597D\u7EC4\u5185\u6392\u5E8F\n\u7528\u4E86\u5206\u6790\u51FD\u6570\u6765\u5B9E\u73B0\u5206\u7EC4\u6392\u5E8F\u548C\u83B7\u53D6\u5206\u7EC4\u6392\u540D\u987A\u5E8F\n\u4E00\u5F00\u59CB\u7528\u4E86\u5DE6\u8FDE\u63A5\uFF0Csubmission\u7684\u65F6\u5019\u53D1\u73B0\u6709\u53EF\u80FD\u5B58\u5728\u7A7A\u503C\u7684\u60C5\u51B5\uFF0C\u6539\u6210\u4E86\u5185\u8FDE\u63A5\uFF0C\u6EE4\u6389\u5DE6\u8868\u53EF\u80FD\u5339\u914D\u4E0D\u5230departmentid\u7684\u60C5\u51B5\n\u6700\u540E\u8FD8\u662F\u7528\u4E86\u5B50\u67E5\u8BE2\u2026\u2026
['Oracle']