Crowdly

Add to Chrome

Which of the following queries returns the second highest salary?

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Which of the following queries returns the second highest salary?

SELECT MAX(Salary) FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees);

0%

SELECT TOP 2 Salary FROM Employees ORDER BY Salary DESC;

0%

SELECT MAX(Salary) FROM (SELECT Salary FROM Employees ORDER BY Salary DESC LIMIT 2);

0%

SELECT Salary FROM Employees ORDER BY Salary DESC LIMIT 2;

0%

More questions like this

Want instant access to all verified answers on lms.musteducation.tn?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us