SQL NOT Keyword

❮ Previous ❮ SQL Keywords Reference Next ❯

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';
Try it Yourself »

❮ Previous ❮ SQL Keywords Reference Next ❯
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.