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