SQL 문제 39 - Nth Highest Salary LeetCode 177

SQL 문제 39 - Nth Highest Salary LeetCode 177 Nth Highest Salary 풀이 -- oracle CREATE FUNCTION getNthHighestSalary(num IN NUMBER) RETURN NUMBER IS sal NUMBER; BEGIN SELECT SALARY INTO sal FROM (SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS RANK FROM EMPLOYEE) WHERE RANK = num AND ROWNUM = 1; RETURN sal; END; -- MYSQL CREATE FUNCTION getNthHighestSalary(num INT) RETURNS INT BEGIN RETURN ( SELECT DISTINCT SALARY FROM ( SELECT SALARY , DENSE_RANK() OVER (ORDER BY SALARY DESC) AS D_RANK FR...

원문링크 : SQL 문제 39 - Nth Highest Salary LeetCode 177