A quantified predicate compares a value with a collection of values. It has the same form as a basic predicate except that the second operand must be a column select expression preceded by an ALL, ANY, or SOME comparison operator. quantified-predicate = --> value-expr --+-> = --+-+-> ALL --+-> ( col-select-expr ) --> +-> <> -+ +-> ANY --+ +-> ^= -+ +-> SOME -+ +-> != -+ +-> < --+ +-> <= -+ +-> > --+ +-> >= -+ The following table describes the value of the result based on the comparison of values for the quantified predicate. Table 8 Quantified Predicate Result Table Comparison of Values Result ALL Quantifier If all comparisons are True True If any comparisons are False False If no comparisons are True made Otherwise Unknown SOME and ANY Quantifiers If any comparisons are True True If all comparisons are False False If no comparisons are True made Otherwise Unknown