Sollicitatievraag bij Tata Consultancy Services

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

Antwoord op sollicitatievraag

Anoniem

27 jun 2012

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