Pregunta de entrevista de Appinventiv
3: Second highest salary ?
Respuesta de la entrevista
Anónimo
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 ?
Anónimo
Too simple if you use the sub query! SELECT MIN(EmpSalary) from ( SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 2 );