SELECT ISNULL( (SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY), null ) AS SecondHighestSalary;
Last updated 2 years ago
Was this helpful?