Tutorialspoint.dev

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


This article is attributed to GeeksforGeeks.org

You Might Also Like

leave a comment

code

0 Comments

load comments

Subscribe to Our Newsletter