<-- Chapter 15: SQL <= Operator

AND/OR Operators are used in SQL statements to filter the Records based on more than one condition. AND Operator display the records in which all the specified conditions are TRUE. OR Operator display the records in which any one of the condition is TRUE

Lets see an example from the below table "employees" :-

AND SQL Statement Example :-

SELECT * 
FROM `employees`
WHERE `name` = 'ABC' AND `name` = 'MNO' ;

Now Run this Query, we will see the output below :-

We can see here, that only those records are displayed which column name values matches 'ABC' and 'MNO'.

OR SQL Statement Example :-

SELECT * 
FROM `employees`
WHERE `name` = 'DEF' OR `name` = 'PQR' ;

Now Run this Query, we will see the output below :-

We can see here, that only those records are displayed which column name values matches either 'DEF' or 'PQR'.