Query Operators

This page provides reference information for the query operators in Databend.

Operator Types

Operator Type	Description
Arithmetic	Mathematical operations (+, -, *, /, %, DIV)
Comparison	Value comparisons (=, !=, <, >, <=, >=, BETWEEN, IN)
Logical	Boolean logic (AND, OR, NOT, XOR)
JSON	JSON data operations (::, ->, ->>, @>, <@)
Set	Combine query results (UNION, INTERSECT, EXCEPT)
Subquery	Nested queries (EXISTS, IN, ANY, ALL, SOME)