MySQL: Advanced SQL Subqueries Exercises

This guide is specifically for MySQL syntax.

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.

MySQL-Specific Notes

This page covers MySQL syntax. Other databases may have different syntax for similar operations.