Amdocs Interview Question
write a query to fetch second highest salary from the department.
Interview Answer
Anonymous
May 13, 2012
select min(sal) from emp where sal > (select min(sal) from emp)
1
write a query to fetch second highest salary from the department.
Anonymous
select min(sal) from emp where sal > (select min(sal) from emp)
Check out your Company Bowl for anonymous work chats.