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

Tata Consultancy Services

Fait partie de Tata Group

Write a query to find second highest salary.

Utilisateur anonyme

15 nov. 2017

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

Utilisateur anonyme

15 nov. 2017

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

Utilisateur anonyme

15 nov. 2017

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