SQL 문제 43 - Department Top Three Salaries LeetCode 185

SQL 문제 43 - Department Top Three Salaries LeetCode 185 Department Top Three Salaries 풀이 -- ORACLE, MSSQL SELECT DEPARTMENT , EMPLOYEE , SALARY FROM ( SELECT D.NAME AS DEPARTMENT , E.NAME AS EMPLOYEE , E.SALARY AS SALARY , DENSE_RANK() OVER (PARTITION BY DEPARTMENTID ORDER BY SALARY DESC) AS RANK FROM EMPLOYEE E INNER JOIN DEPARTMENT D ON E.DEPARTMENTID = D.ID ) T WHERE T.RANK < 4 ORDER BY DEPARTMENT, SALARY DESC -- MYSQL SELECT DEPARTMENT , EMPLOYEE , SALARY FROM ( SELECT D.NAME AS DEPARTMENT , ...

원문링크 : SQL 문제 43 - Department Top Three Salaries LeetCode 185