December 2002
Intermediate to advanced
928 pages
85h 29m
English
A group condition compares an expression to a group of results. The syntax for a group comparison is:
[(]expr[,expr. . .][)]simple_conditionANY | SOME | ALL | IN| NOT IN (subquery|expression_list[,subquery|expression_list. . .])
If you use multiple expressions on the left of the condition, you must have an equal number of values, with matching datatypes, on the right of the condition.
If any values on the right of the NOT IN condition evaluate to NULL, then the condition always evaluates to FALSE. If the values on the right of the NOT IN condition constitute a subquery that returns no rows, all rows in the parent query containing the condition are returned.