SQL – And , Or , Not Operator
Table Of Contents:
- What Is And , Or , Not Operator.
- Syntax Of And , Or , Not Operator.
- Examples Of And , Or , Not Operator.
(1) What Is And , Or , Not Operator
- And , Or, Not Operator can be used with the “Where” clause.
- The
AND
operator displays a record if all the conditions separated byAND
are TRUE. - The
OR
operator displays a record if any of the conditions separated byOR
is TRUE. - The
NOT
operator displays a record if the condition(s) is NOT TRUE.
(2) Syntax Of And , Or , Not Operator
AND Syntax
SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;
OR Syntax
SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2 OR condition3 ...;
NOT Syntax
SELECT column1, column2, ...
FROM table_name
WHERE NOT condition;
(3) Examples Of And , Or , Not Operator
Demo Data:
Example-1: AND Operator
SELECT * FROM Customers
WHERE Country='Germany' AND City='Berlin';
Example-2: OR Operator
SELECT * FROM Customers
WHERE City='Berlin' OR City='München';
Example-3: NOT Operator
SELECT * FROM Customers
WHERE NOT Country='Germany';
Example-4: Combining AND, OR and NOT
SELECT * FROM Customers
WHERE Country='Germany' AND (City='Berlin' OR City='München');
Example-5: Combining AND, OR and NOT
SELECT * FROM Customers
WHERE NOT Country='Germany' AND NOT Country='USA';