CHAPTER 6Subqueries
All the queries you’ve seen so far in this book have contained just one SELECT statement. In this chapter, you will learn the following:
How to place an inner SELECT statement within an outer SELECT, UPDATE, or DELETE statement. The inner SELECT is known as a subquery.
The features of the different types of subqueries.
How subqueries allow you to build up very complex statements from simple components.
Types of Subqueries
There ...
Get Oracle Database 11g SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
