> Home > Scripts > SQL
Example of a not in statement:
The purpose of the not in statement is to exclude data that matches a case in the set.
SELECT NAME
FROM CUSTOMER_ADDRESS
WHERE STATE NOT IN ('TX','LA','MS')
;