Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
These are the logical operators for boolean values:AND, OR, NOT. SQL uses a three-valued logic system with true, false, and null, which represents “unknown”.
a |
b |
a AND b |
a OR b |
|---|---|---|---|
| TRUE | TRUE | TRUE | TRUE |
| TRUE | FALSE | FALSE | TRUE |
| TRUE | NULL | NULL | TRUE |
| FALSE | FALSE | FALSE | FALSE |
| FALSE | NULL | FALSE | NULL |
| NULL | NULL | NULL | NULL |
a |
NOT a |
|---|---|
| TRUE | FALSE |
| FALSE | TRUE |
| NULL | NULL |
The operators AND and OR are commutative, that is, you can switch the left and right operand without affecting the result.