The table is:
So far, I’ve found two ways to do this
SELECT TOP(1) * FROM (SELECT TOP(2) * FROM Salary ORDER BY Amount DESC) AS TOP2 ORDER BY Amount
SELECT MAX(Amount) FROM Salary WHERE Amount Not In (SELECT MAX(Amount) FROM Salary)
I personally like the “TOP()” approach just because of its flexibility. If I want to select third, fourth, or fifth highest record, all I need to do is change the number in the second TOP() statement.