Here ‘s the problem statement https://leetcode.com/problems/second-highest-salary/
My Solution:
WITH SALARY_RANKING AS (
SELECT
Salary,
DENSE_RANK() OVER (ORDER BY salary DESC) [ranking]
FROM Employee
), RESULT_SET AS (
SELECT DISTINCT Salary
FROM SALARY_RANKING
WHERE ranking = 2
)
SELECT (SELECT Salary FROM RESULT_SET) [SecondHighestSalary]