IN
Use in operator to check if the value exists in the set of values.
The set of values can be in any random order.
IN operator can be used with any data type. If character or data type values are used in the list, enclose them with single quotes ' ' .
Examples:
list of values can be from a select query.
If Values in the IN list are character type, enclose them in single quotes.