Last updated 3 years ago
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;