Appinventiv interview question
3: Second highest salary ?
Interview Answer
Anonymous
19 Feb 2018
Too simple if you use the sub query! SELECT MIN(EmpSalary) from ( SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 2 );
2
3: Second highest salary ?
Anonymous
Too simple if you use the sub query! SELECT MIN(EmpSalary) from ( SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 2 );
Check out your Company Bowl for anonymous work chats.