Logical Conditions ( AND, OR, NOT Operators)

• A Logical condition combines the result of two component conditions to produce a single based on them or inverts the result of a single condition.
• A row is returned only if the overall result of the condition is true.
• Three logical operators are available in SQL:

OPERATOR                             MEANING

AND                                         Returns TRUE if both component conditions are true.
OR                                            Returns TRUE if either component condition is true.
NOT                                         Returns TRUE if the following condition is false.

(For examples see next posts)