Chapter 7. Subqueries

A subquery is a SELECT statement nested in various clauses of a SQL statement. It allows you to use the output from one query as the input of another SQL statement. Subqueries make it easy to break down problems into logical and manageable pieces.

Lab 7.1 Simple Subqueries

As mentioned, a subquery allows you to break down a problem into individual components and solve it ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

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