# Subquery

*noun*

say it: **“SUB-kweer-ee”** **/ˈsʌbkwɪəri/**

A query written inside another query, in parentheses.

## What is **Subquery** in a relational database?

**Subquery** — A query nested inside another SQL statement.

```sql
SELECT order_id
FROM purchase_order
WHERE total_amount > (
    SELECT AVG(total_amount)
    FROM purchase_order
);
```

## In a sentence

- “A **subquery** found the average price, and the outer query kept products above it.”

Level: Apprentice · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/subquery
