Infor interview question

find Second maximum salary using sql

Interview Answer

Anonymous

26 Oct 2016

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