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