Chapter 13. Subqueries

A subquery is a SELECT statement that is placed within parentheses inside another SQL statement. This chapter discusses how to use subqueries. It covers the following exam topics:

• Type of subqueries

• Using each type of subquery

• Converting subqueries to inner and outer joins

• Using subqueries in statements that modify tables