9Retrieving Data Using Subqueries
CERTIFICATION OBJECTIVES
9.02 Describe the Types of Problems That Subqueries Can Solve
9.03 List the Types of Subqueries
9.04 Write Single-Row and Multiple-Row Subqueries
9.05 Write a Multiple-Column Subquery
9.06 Use Scalar Subqueries in SQL
9.07 Solve Problems with Correlated Subqueries
9.08 Update and Delete Rows Using Correlated Subqueries
9.09 Use the EXISTS and NOT EXISTS Operators
This chapter looks at subqueries. A subquery is a SELECT statement within a larger SQL statement. The subquery concept builds on many of the features ...
Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) 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.