Construction should include subqueries that return more than one value, using the following multiple-row comparison operators and guidelines for their use:
- IN—used when the outer query WHERE clause is designed to select only those rows that are equal to one of the lists of values returned from the inner query
- ANY—used when the outer query WHERE clause is designed to select the rows that are equal to, less than, or greater than at least one value in the subquery result set
- ALL—used when the outer query WHERE clause is designed to select the rows that are equal to, less than, or greater than all values in the subquery result set
- IN, ANY, ALL, and NOT—used in combination with standard comparison operators (+, >, <, >=, <=)