Subqueries

        A subquery is a query within a query. You can create subqueries within your SQL statements. These subqueries can reside in the ‘WHERE’ clause, the ‘FROM’ clause, or the ‘SELECT’ clause.

• Single-row-subquery
• Multi-row-subquery
• Correlated-subquery