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), etc.
| Category | Operators |
|---|---|
| Arithmetic Operators | |
+ , - , * , / , % |
|
| Comparison Operators | |
= , != , <> , < , <= , > , >= |
|
| Logical/Boolean Operators | |
| AND , NOT , OR | |
| Set Operators | |
| INTERSECT, MINUS, EXCEPT, UNION | |
| Subquery Operators | |
| [NOT] EXISTS, ANY / ALL, [NOT] IN |