Tata Consultancy Services Interview Question: Write a query to find second highest salary.

Notifications

Tata Consultancy Services

Write a query to find second highest salary.

Anonymous

Nov 15, 2017

select max(salary) from tablename where salary<(select max(salary) from tablename);

Anonymous

Nov 15, 2017

select max(salary) from tablename where salary < (select max(salary) from tablename);

Anonymous

Nov 15, 2017

select max(salary) from tablename where salary (is less than)(<) (select max(salary) from tablename);