FIGmd interview question

Write query to find second max salary

Interview Answer

Anonymous

Aug 9, 2019

SELECT MAX (salary) from employees where salary NOT IN (SELECT MAX (SALARY ) FROM EMPLOYEE) ;