SQL 문제 41 - Department Highest Salary LeetCode 184

SQL 문제 41 - Department Highest Salary LeetCode 184 Department Highest Salary 풀이 -- ORACLE SELECT T.Department, T.EMPLOYEE, T.SALARY FROM ( SELECT D.NAME AS Department , E.NAME AS EMPLOYEE , E.SALARY AS SALARY , RANK() OVER(PARTITION BY D.ID ORDER BY E.SALARY DESC) RANK FROM EMPLOYEE E INNER JOIN DEPARTMENT D ON E.DEPARTMENTID = D.ID ) T WHERE T.RANK = 1; -- MYSQL, MSSQL SELECT T.Department, T.EMPLOYEE, T.SALARY FROM ( SELECT D.NAME AS Department , E.NAME AS EMPLOYEE , E.SALARY AS SALARY , RANK()...

원문링크 : SQL 문제 41 - Department Highest Salary LeetCode 184