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


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.