Not
The NOT command is used with WHERE to only include rows where a condition is not true.
The following SQL statement selects all fields from "Customers" where country is NOT "Germany":
Example
SELECT * FROM Customers
WHERE
NOT Country='Germany';Loading lesson path
The NOT command is used with WHERE to only include rows where a condition is not true.
The following SQL statement selects all fields from "Customers" where country is NOT "Germany":
Example
SELECT * FROM Customers
WHERE
NOT Country='Germany';