image
CHAPTER
6
Subqueries
In this chapter, you’ll learn how to perform the following tasks:
image   Place an inner SELECT statement within an outer SQL statement. The inner SELECT is called a subquery.
image   Use the different types of subqueries.
image   Create complex statements from simple components.
Types of Subqueries
There are two basic types of subqueries:

Get Oracle Database 12c SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.