> 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')

;