Domanda di colloquio di Amdocs
Find the second highest salary among the given table. (SQL)
Risposta di colloquio
Anonimo
5 mar 2020
select name, max(salary) from employee where salary < (select max(salary) from employee);
Find the second highest salary among the given table. (SQL)
Anonimo
select name, max(salary) from employee where salary < (select max(salary) from employee);