PureSoftware interview question
Q - Write a query to find 2nd largest salary in the SQL table
Interview Answer
Anonymous
17 Oct 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
Anonymous
SELECT MAX(Salary) AS SecondHighestSalary FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees);
Check out your Company Bowl for anonymous work chats.