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