August 2009
Intermediate to advanced
960 pages
21h 21m
English
Content preview from Oracle SQL By Example Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 8. 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 8.1 Simple Subqueries
As mentioned earlier, a subquery allows you to break down a ...