Pergunta de entrevista da empresa Deloitte

Second highest salary with SQL?

Resposta da entrevista

Sigiloso

7 de jun. de 2017

SELECT name, MAX(salary) AS salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);