• I got it with this:

    SELECT TOP 1 EmpID, MAX(EmpWage) AS [Max Wage]

    FROM EmpDetails

    GROUP BY EmpID

    HAVING MAX(EmpWage) < (SELECT TOP 1 MAX(EmpWage) FROM EmpDetails)

    ORDER BY [Max Wage] DESC