Pregunta de entrevista de Systango
2 ways to write an sql query for second highest salary
Respuesta de la entrevista
Anónimo
17 sept 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
Anónimo
select max(salary) from tablename where salary NOT IN (select (max) salary from tablename);