查询运算符
Snowflake 支持 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.