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	`**`
Logical operators	AND , NOT , OR
Set operators	INTERSECT, MINUS, EXCEPT, UNION
Subquery operators	[NOT] EXISTS, ANY / ALL, [NOT] IN