Specify a quantified comparison.
|♦||The degree of the row value predicand, table subquery and row value expressions shall be 1.|
|♦||The data types shall be comparable.|
|♦||The predicate evaluates to TRUE if the row value predicand has a matching value in the list of values specified by the in predicate value, else to FALSE.|
|♦||If the row value predicand is null, then the predicate evaluates to UNKNOWN.|
|♦||The NOT operator inverts the meaning of the comparison and is equal to:|
NOT ( <row value predicand> IN <in predicate value> )
|1)||The following example selects students from California and New York:|
SELECT studentName, state
WHERE state IN ( 'CA', 'NY' )
|2)||The following examples uses a subquery with the IN predicate to select students who are enrolled in courseID 730:|
SELECT studentID, studentName
WHERE studentID IN ( SELECT studentID FROM enrolls WHERE courseID = 730 )
Feature F561 "Full value expressions"