Query operators¶
Snowflake supports most of the standard operators defined in SQL:1999.
These operators include arithmetic operators (such as + and -),
set operators (such as UNION), subquery operators (such as ANY), and so on.
| Category | Operators |
|---|---|
| Arithmetic operators | + , - , * , / , % |
| Comparison operators | = , != , <> , < , <= , > , >= |
| Expansion operators | ** |
| Flow operators | ->> |
| Logical operators | AND , NOT , OR |
| Set operators | INTERSECT, MINUS, EXCEPT, UNION |
| Subquery operators | [NOT] EXISTS, ANY / ALL, [NOT] IN |
See also Bitwise expression functions.