Home / Glossary / Subquery

Subquery

SFBy Sitraka Forler · Lecturer, Durham Business School·Updated 13 September 2026· About this site

A query nested inside another query.

Subqueries can appear in SELECT, FROM, or WHERE clauses. A correlated subquery references the outer query's rows. CTEs are often preferred over subqueries for readability in complex analytical queries.

SELECT * FROM equity_prices
WHERE close > (SELECT AVG(close) FROM equity_prices);