Tata Consultancy Services
Parte di Tata Group
Azienda coinvolta
Domanda di colloquio di Tata Consultancy Services
Technical Question : - Write a SQL query to get the second highest salary from an EMPLOYEE table.
Risposta di colloquio
Anonimo
27 giu 2012
select max(sal) from employee where sal not in (select max(sal) from employee )