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