2019-06-19 20:48:30

SELECT 2nd highest salary in the employee table.

SELECT MAX(Salary)
FROM   Employee
WHERE  Salary NOT IN ( SELECT MAX(Salary)
                       FROM Employee )

Copyright © 2024 delaney. All rights reserved.