Logical Operators
OR Logical OR
OR represents a logical OR operation, which takes two predicates and filters for either one being true.
Examples
SELECT * FROM (SELECT 5 AS a, 10 AS b) WHERE A = 5 OR B = 2
| a | b |
|---|---|
| 5 | 10 |
SELECT * FROM (SELECT 5 AS a, 10 AS b) WHERE A = 3 OR B = 2
| a | b |
|---|
AND Logical AND
AND represents a logical AND operation, which takes two predicates and filters for both being true.
Examples
SELECT * FROM (SELECT 5 AS a, 10 AS b) WHERE A = 5 AND B = 2
| a | b |
|---|
SELECT * FROM (SELECT 5 AS a, 10 AS b) WHERE A = 5 AND B = 10
| a | b |
|---|---|
| 5 | 10 |
NOT Logical NOT
NOT inverts the boolean value. This can be combined with other operators to create their inverse operations, i.e NOT IN, NOT WITHIN.
Example
SELECT NOT TRUE
| column |
|---|
| false |