Pergunta de entrevista da empresa PureSoftware
Q - Write a query to find 2nd largest salary in the SQL table
Resposta da entrevista
Sigiloso
17 de out. de 2024
SELECT MAX(Salary) AS SecondHighestSalary FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees);