Subquery

A query nested inside another SQL statement.

What is Subquery in a relational database?

Subquery — A query nested inside another SQL statement.

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

Level: Apprentice · More Database terms at this level

Updated