SQL
Operators
WHERE clause could be used with AND, OR and NOT operators. AND and OR operators are used to filter records based on more than one condition.
- AND operator is used where we want to display record if all the conditions separated by AND is TRUE.
- OR operator is used where we want to display record if any of the condition separated by OR is TRUE.
- NOT operator display a record if the condition is NOT TRUE.
AND Operator
Syntax
SELECT DISTINCT column1, column2....columnN
FROM table_name
WHERE condition1 AND condition2....columnN;
Example
SELECT * FROM Customers
WHERE Country='pakistan' AND City='sargodha';
OR Operator
Syntax
SELECT DISTINCT column1, column2....columnN
FROM table_name
WHERE condition1 OR condition2...;
Example
SELECT * FROM Customers
WHERE Country='pakistan' AND City='sargodha';
NOT Operator
Syntax
SELECT DISTINCT column1, column2....columnN
FROM table_name
WHERE NOT condition;
Example
SELECT * FROM Customers
WHERE NOT Country='USA';