Chapter 12Using Subqueries to Access and Modify Data

Copyright © 2009 by The McGraw-Hill Companies. Click here for terms of use.

Key Skills & Concepts

Image Create Subqueries That Return Multiple Rows

Image Create Subqueries That Return One Value

Image Work with Correlated Subqueries

Image Use Nested Subqueries

Use Subqueries to Modify Data

Subqueries, like joins, provide ...

Get SQL: A Beginner's Guide, Third Edition, 3rd Edition 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.