求问一道SQL高频题

在Leetcode里面选Oracle，然后用以下query

SELECT d.Name AS Department, e.Name As Employee, e.Salary AS Salary
FROM
(SELECT DepartmentId, Name, Salary, rank() over (partition by DepartmentId order by Salary desc) as Rank
.1point3acresFROM Employee) e
INNER JOIN Department d
ON e.DepartmentId = d.Id
WHERE e.Rank =1