Domanda di colloquio di Systango
2 ways to write an sql query for second highest salary
Risposta di colloquio
Anonimo
17 set 2019
select max(salary) from tablename where salary NOT IN (select (max) salary from tablename);
1
2 ways to write an sql query for second highest salary
Anonimo
select max(salary) from tablename where salary NOT IN (select (max) salary from tablename);