Question d’entretien chez ThinkSys

Write a sql query for second highest salary.

Réponse à la question d'entretien

Utilisateur anonyme

12 mars 2019

select salary from (select * from table_name order by salary desc limit 2) as emp order by salary asc limit 1;