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

See also Bitwise Expression Functions.