Domanda di colloquio di ThinkSys

Write a sql query for second highest salary.

Risposta di colloquio

Anonimo

12 mar 2019

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