SQL IN operator
IN operator is used to test for a value that matches any one of the values from a fixed set of values.
If you use the OR operator for the same column multiple times –
This time, I wish to select the StateProvince where State Province code is either AK, AZ, CO, MB or ID, then you can simply code as –
NOT IN Operator
In the same way, if I wish to get all the StateProvince which do not fall within AK, AZ, CO, MB or ID, then I can simply use NOT IN operator for this purpose.