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 , ...
#
DepartmentTopThreeSalaries_LeetCode185
#
SQL
#
SQL_DepartmentTopThreeSalaries
#
SQL_DepartmentTopThreeSalaries_LeetCode185
#
SQL_LeetCode185
