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

Jun 27, 2012

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