Pergunta de entrevista da empresa Appinventiv

3: Second highest salary ?

Resposta da entrevista

Sigiloso

19 de fev. de 2018

Too simple if you use the sub query! SELECT MIN(EmpSalary) from ( SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 2 );

2