Pergunta de entrevista da empresa Amdocs
write a query to fetch second highest salary from the department.
Resposta da entrevista
Sigiloso
13 de mai. de 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.
Sigiloso
select min(sal) from emp where sal > (select min(sal) from emp)