Pergunta de entrevista da empresa ThinkSys

Write a sql query for second highest salary.

Resposta da entrevista

Sigiloso

12 de mar. de 2019

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