NOT IN in Teradata

The NOT IN operator allows you to specify multiple values in a WHERE clause.

Syntax:
expression NOT IN (value1, value2, .... value_n);


Example:
SELECT *
FROM laptops
WHERE product_name NOT IN ('IBM', 'Hewlett Packard', 'Microsoft');


The above example is equivalent to
SELECT *
FROM laptops
WHERE product_name <> 'IBM'
OR product_name <> 'Hewlett Packard'
OR product_name <> 'Microsoft';


NOT IN with Numeric values:
SELECT *
FROM orders
WHERE order_id NOT IN (10000, 10001, 10003, 10005);