Determines whether a given value matches any value in a query or a list
Format
expression [ NOT ] IN ( { query-expr | expr-list } )
Remarks
Determines if the value of the expression matches one of the values in either the result set from a query or a comma separated list.
If an item in the list is an array then determines if the value matches an element in the array.
Expression IN ( QueryExpr )
is the same as
Expression = ANY ( QueryExpr )
Expression NOT IN ( QueryExpr )
is the same as
Expression <> ALL ( QueryExpr )
Example:
SELECT Name FROM Customers WHERE Country IN ('UK', 'USA', 'Germany')