Correlated Subquery
noun
say it: “KOR-uh-lay-tid SUB-kweer-ee” /ˈkɔːrəleɪtɪd ˈsʌbkwɪəri/
A subquery that uses a value from the outer query, so it runs once for each outer row.
What is Correlated Subquery in a relational database?
Correlated Subquery — A subquery that refers to values from an outer query and is evaluated in that context.
SELECT customer_id
FROM customer
WHERE EXISTS (
SELECT 1
FROM purchase_order
WHERE purchase_order.customer_id = customer.customer_id
);
In a sentence
- “A correlated subquery finds each product priced above its own category's average.”
Level: Journeyman · More SQL terms at this level
Updated