Introduction to Subqueries

A subquery is a query inside another query.

Find employees earning more than average:

SELECT * FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);

The inner query runs first, returns a value, then the outer query uses it.

Subqueries can appear in:

• WHERE clause (most common)
• FROM clause
• SELECT clause