Pergunta de entrevista da empresa WhiteHedge Technologies

oracle second heighest salary from employee table query

Resposta da entrevista

Sigiloso

26 de ago. de 2024

SELECT MAX(salary) AS second_highest_salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee);