Domanda di colloquio di PureSoftware
Q - Write a query to find 2nd largest salary in the SQL table
Risposta di colloquio
Anonimo
17 ott 2024
SELECT MAX(Salary) AS SecondHighestSalary FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees);
Q - Write a query to find 2nd largest salary in the SQL table
Anonimo
SELECT MAX(Salary) AS SecondHighestSalary FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees);