There are three logical operators that may be used in a WHERE clause.
The logical operators allow you to limit rows based on logical conditions.
The logical operators are listed in the following table:
OperatorDescription
x AND yReturns true when both x and y are true
x OR yReturns true when either x or y is true
NOT xReturns true if x is false, and returns false if x is true