Frage im Vorstellungsgespräch bei Tata Consultancy Services

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

Antwort im Vorstellungsgespräch

Anonym

27. Juni 2012

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