Pregunta de entrevista de Tata Consultancy Services

Technical Question : - Write a SQL query to get the second highest salary from an EMPLOYEE table.

Respuesta de la entrevista

Anónimo

27 de jun de 2012

select max(sal) from employee where sal not in (select max(sal) from employee )