O'Reilly logo

Oracle Database 12c SQL by Jason Price

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required