SQL AND, OR and NOT operators are used for filtering the records based on one or more conditions. The AND, OR operators are used with where clause. It can also be combined with the NOT  operators. The AND OR operator is also known as Conjunctive  operators.

SQL AND OR NOT Operator

AND, OR operator is also known as Conjunctive operators.

1. The AND operator displays the record only if the conditions separated by AND operator results in True. All the conditions separated by AND operator should be true; otherwise, it will not display all the records.
2. The OR operator displays the records if either of the conditions separated by OR operator results in True.
3. The NOT operator displays the record if the condition is false.

#sql #conjunctive #operator