Usage and Example of SQL NOT Keyword

SQL Keyword Reference

NOT

The NOT command is used with WHERE to query rows where the condition is not met.

The following SQL statement selects all fields from the 'Customers' table where the country is not 'Germany':

SELECT　*　FROM Customers
WHERE NOT Country='Germany';

SQL Keyword Reference