Operator Type | Operator |
Logical operator | AND, NOT, OR |
Comparison operator | <, >, <= ,>= , = , <>, !=, BETWEEN, IN, such as IN ('a', 'b', 'c') |
Pattern matching operator | LIKE |
Mathematical operator | +, -, *, % |
Operator/Element | Association | Use Case |
- | Right | Unary subtraction |
*, /, % | Left | Multiplication, division, and modulo |
+, - | Left | Addition and subtraction |
IN | - | Setting membership |
BETWEEN | - | In the range of () |
LIKE | - | String pattern matching |
<> | - | Less than and greater than |
= | Right | Equivalence and assignment |
NOT | Right | Logical NOT |
AND | Left | Logical AND |
OR | Left | Logical OR |
Was this page helpful?