FIGmd interview question

Write query to find second max salary

Interview Answer

Anonymous

9 Aug 2019

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