Skip to content

Query Operators

Operators include arithmetic operators (+, -, etc.), set operators (UNION, INTERSECT, etc.), subquery operators (ALL, ANY, etc.), and more.

Summary Table

CategoryOperators
Arithmetic Operators+, -, *, /, %
Comparison Operators=, !=, <>, <, <=, >, >=
Logical OperatorsAND, NOT,OR
Set OperatorsINTERSECT, MINUS, EXCEPT, UNION
Subquery Operators[NOT] EXISTS, ANY / ALL, [NOT] IN