#176 Second Highest Salary

SELECT ISNULL(
    (SELECT DISTINCT Salary
    FROM Employee
    ORDER BY Salary DESC
    OFFSET 1 ROWS
    FETCH NEXT 1 ROWS ONLY), null
) AS SecondHighestSalary;

Last updated

Was this helpful?