Question d’entretien chez Amdocs
Find the second highest salary among the given table. (SQL)
Réponse à la question d'entretien
Utilisateur anonyme
5 mars 2020
select name, max(salary) from employee where salary < (select max(salary) from employee);
Find the second highest salary among the given table. (SQL)
Utilisateur anonyme
select name, max(salary) from employee where salary < (select max(salary) from employee);