Table Subquery
noun
say it: “TAY-bul SUB-kweer-ee” /ˈteɪbəl ˈsʌbkwɪəri/
A subquery that returns rows and columns, used in FROM as if it were a table.
What is Table Subquery in a relational database?
Table Subquery — A subquery producing rows and columns that another query can use as a table.
SELECT recent.order_id
FROM (
SELECT order_id
FROM purchase_order
WHERE ordered_on >= DATE '2026-01-01'
) AS recent;
In a sentence
- “A table subquery worked out order totals, and the outer query averaged them.”
Level: Apprentice · More SQL terms at this level
Updated