What is a Subquery?
A subquery is a query nested inside another SQL statement. It can be used in SELECT, FROM, or WHERE clauses to return data that the outer query can use.
- Scalar and Row Subqueries
- Correlated Subqueries
- IN, EXISTS, ANY, ALL conditions