SQL

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 ) …

SECOND HIGHEST SALARY – LEETCODE Read More »