Advanced-level SQL Subqueries practice exercises with solutions.
Exercise 1
Question: Find the second highest salary in the company.
SELECT MAX(salary) AS second_highest FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
Nested subqueries can solve complex problems. Here we find the max salary that is less than the overall max.