Infor interview question

find Second maximum salary using sql

Interview Answer

Anonymous

Oct 26, 2016

SELECT max(salary) FROM Employee WHERE salary < (SELECT max(salary) FROM Employee);