Pergunta de entrevista da empresa Tata Consultancy Services: Write a query to find second highest salary.

Tata Consultancy Services

Parte da empresa Tata Group

Write a query to find second highest salary.

Sigiloso

15 de nov. de 2017

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

Sigiloso

15 de nov. de 2017

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

Sigiloso

15 de nov. de 2017

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