Domanda di colloquio di Appinventiv
3: Second highest salary ?
Risposta di colloquio
Anonimo
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 ?
Anonimo
Too simple if you use the sub query! SELECT MIN(EmpSalary) from ( SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 2 );