Chapter 8. Subqueries

Chapter Objectives

In this chapter, you will learn about:

• Simple Subqueries

• Correlated Subqueries

• Inline Views and Scalar Subquery Expressions

• ANY, SOME, and ALL Operators in 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

Lab Objectives

After this lab, you will be able to:

• Write Subqueries in the WHERE and HAVING Clauses

• Write Subqueries That Return Multiple Rows

• Write Subqueries That Return Multiple Columns

As mentioned earlier, a subquery allows you to break down a ...

Get Oracle SQL By Example 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.

Start your free trial