The IN operator in SQL is used to filter records based on whether a column's value matches any value in a specified list. ... Example 2: Using NOT IN Operator. The NOT IN operator excludes rows where ...

It is not uncommon to use the IN operator in WHERE statement. Such an example is the filtering operation by enumerated values, say, the customer age groups, by regions, or by orders. An IN condition ...