ThinkSys interview question

Write a sql query for second highest salary.

Interview Answer

Anonymous

12 Mar 2019

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