184. Department Highest Salary.mysql

# Write your MySQL query statement below
SELECT DEPARTMENT,EMPLOYEE,SALARY FROM(
SELECT
D.NAME AS DEPARTMENT,
E.NAME AS EMPLOYEE,
E.SALARY,
DENSE_RANK() OVER(PARTITION BY D.NAME ORDER BY E.SALARY DESC) AS RN
FROM EMPLOYEE E
INNER JOIN DEPARTMENT D
ON E.DEPARTMENTID=D.ID) AS TAB
WHERE RN=1