Subqueries as Filters
In Chapter 6, you learned how to filter the information retrieved by adding a WHERE clause. You also learned how to use both simple and complex comparisons to get only the rows you want in your result set. Now we’ll build on your skills and show you how to use a subquery as one of the comparison arguments to do more sophisticated filtering.
Syntax
Let’s revisit the SELECT statement from Figure 11-1 and look at the syntax for building a query with a simple comparison predicate in a WHERE clause. Figure 11-5 shows the simplified diagram.
Figure 11-5. Filtering a result using a simple comparison predicate
As you remember from Figure 11-2, a value expression can be a subquery. In the simple example ...
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second 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.
