Pregunta de entrevista de Amdocs
Find the second highest salary among the given table. (SQL)
Respuesta de la entrevista
Anónimo
5 de mar de 2020
select name, max(salary) from employee where salary < (select max(salary) from employee);
Find the second highest salary among the given table. (SQL)
Anónimo
select name, max(salary) from employee where salary < (select max(salary) from employee);