What is a subquery?

SQL subqueries, CTEs and set operations · Freshers

Model answer

A query nested inside another query, in parentheses. It can appear in WHERE (WHERE price > (SELECT AVG(price) FROM products)), in FROM as a derived table, or in SELECT as a scalar value. Subqueries make some questions simple to express.

Learn this topic

Subqueries, EXISTS and CTEs: Queries Inside Queries in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is a correlated subquery?
• What is a CTE and why use one?
• What is a recursive CTE and when is it used?
• What is the difference between a CTE, a view and a temporary table?
• What do INTERSECT and EXCEPT do?
• Why is NOT IN dangerous with NULLs?