employer cover photo
employer logo
employer logo

Tata Consultancy Services

Part of Tata Group

Engaged employer

Tata Consultancy Services interview question

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

Interview Answer

Anonymous

27 June 2012

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