Subqueries Returning Zero or More Values

This group includes subqueries introduced with IN, NOT IN, or a comparison operator and ANY or ALL. There is no limit on the number of rows these subqueries can return. (Subqueries introduced with an unmodified comparison operator can return no more than one row.)

Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.