laika222
10/31/2016 - 6:11 PM

WHERE NOT selects rows that are not equal to a value. It ignores NULL values, so in the example, rows that have a country that is not 'USA'

WHERE NOT selects rows that are not equal to a value. It ignores NULL values, so in the example, rows that have a country that is not 'USA' but are NULL will not be included.

SELECT * from Customers2
WHERE NOT (Country='USA');