Describe briefly the term a subquery

Question

Describe briefly the term a subquery?

Answer 1

A subquery is a query which is part of two queries. The first query (or inner query) is in the WHERE clause of the other query (or outer query). In some cases the inner query offers outcomes for the outer query to process. In other cases, the outer query outcomes offer outcomes for the inner query (or correlated subquery).