SQL | NOT Operator

NOT Syntax
SELECT column1, colomn2, … FROM table_name WHERE NOT condition;
Demo Database
Below is a selection from the “Customers” table in the Northwind sample database:

Customer ID	Customer Name	City	PostalCode	Country
1	John Wick	New York	1248	USA
2	Around the Horn	London	WA1 1DP	UK
3	Rohan	New Delhi	100084	India

NOT Example
The following SQL statement selects all fields from “Customers” where country is not “UK”
SELECT * FROM Customers WHERE NOT Country=’UK’;

Customer ID	Customer Name	City	PostalCode	Country
1	John Wick	New York	1248	USA
3	Rohan	New Delhi	100084	India

Combining AND, OR and NOT
You can also combine the AND, OR and NOT operators.
Example:
1.) SELECT * FROM Customers WHERE NOT Country=’USA’ AND NOT Country=’UK’;

Customer ID	Customer Name	City	PostalCode	Country
3	Rohan	New Delhi	100084	India

My Personal Notes arrow_drop_up

Save