Pergunta de entrevista da empresa Amdocs

Find the second highest salary among the given table. (SQL)

Resposta da entrevista

Sigiloso

5 de mar. de 2020

select name, max(salary) from employee where salary < (select max(salary) from employee);