Pregunta de entrevista de Tata Consultancy Services

Write a query to find second highest salary.

Respuestas de entrevistas

Anónimo

15 nov 2017

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

Anónimo

15 nov 2017

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

Anónimo

15 nov 2017

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