NOT

The NOT command is employed with WHERE to exclusively include rows where a condition is false. The following SQL statement selects all fields from “Customers” where the country is not “Germany”:

Example

SELECT * FROM Customers
WHERE NOT Country=‘Germany’;