Amdocs interview question
Find the second highest salary among the given table. (SQL)
Interview Answer
Anonymous
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)
Anonymous
select name, max(salary) from employee where salary < (select max(salary) from employee);
Check out your Company Bowl for anonymous work chats.