[SQL] leetcode Second Highest Salary

 

https://leetcode.com/problems/second-highest-salary/

Second Highest Salary - LeetCode

 

 

두번째로 연봉이 높은 직원을 출력하는 문제입니다.

풀이 : rank over 윈도우 함수 사용

 

[Oracle 풀이]

select sum(salary)  as "SecondHighestSalary" from (
select salary, rank() over (order by salary desc) as rank  from employee) where rank = 2;