Pergunta de entrevista da empresa Airbus

Write a query to fetch the second highest salary details from Employee table.

Resposta da entrevista

Sigiloso

18 de jan. de 2016

select Max(emp.salary) from employee emp where emp.salary < ( select Max (e.salary)) from employee e )