This guide is specifically for SQL Server 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.
SQL Server-Specific Notes
This page covers SQL Server syntax. Other databases may have different syntax for similar operations.