#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?
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?