THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Operator | Operand types | Description |
|---|---|---|
A AND B | boolean | TRUE if both A and B are TRUE, otherwise FALSE. NULL if A or B is NULL. |
A OR B | boolean | TRUE if either A or B or both are TRUE, FALSE OR NULL is NULL, otherwise FALSE. |
NOT A | boolean | TRUE if A is FALSE or NULL if A is NULL. Otherwise FALSE. |
! A | boolean | Same as NOT A. |
A IN (val1, val2, ...) | boolean | TRUE if A is equal to any of the values. |
A NOT IN (val1, val2, ...) | boolean | TRUE if A is not equal to any of the values. |
[NOT] EXISTS (subquery) | boolean | TRUE if the subquery returns at least one row. |
...