Duration: 17:51 min
Summary: Today, we will talk about subqueries, which are queries within queries. The outermost query is a query which resultset is returned to the caller. It is known as the outer query. The inner query is a query which result is used by the outer query. It is known as a subquery. The subquery can be self-contained or correlated. A self-contained subquery does not depend on the outer query that it belongs to. But the correlated subquery does. We will see examples of both.