[SQL] leetCode Department Top Three Salaries

https://leetcode.com/problems/department-top-three-salaries/

Department Top Three Salaries - LeetCode

부서별로 연봉순위 3위까지 출력하는 문제입니다. 단 동일한 연봉인 경우 동일 순위로 판단합니다. (1등이 2명이더라도 다음 순위는 2등으로 판별)

DENSE RANK 함수를 사용하였습니다.

[Oracle 풀이]

 

SELECT  
	D.NAME AS Department
	, E.NAME AS Employee
    , E.SALARY AS Salary 
FROM 
    (SELECT  
        departmentId 
        , NAME 
        , SALARY
        , DENSE_RANK() OVER (PARTITION BY DEPARTMENTID ORDER BY SALARY DESC ) AS RANK 
     FROM EMPLOYEE) E
INNER JOIN department D
     ON E.RANK <= 3
     AND D.ID = E.departmentId