<div class="section" id="query-operators">
<h1>Query Operators<a class="headerlink" href="#query-operators" title="Permalink to this headline">¶</a></h1>
Snowflake supports most of the standard operators defined in SQL:1999.
These operators include arithmetic operators (such as <code class="docutils literal notranslate">+</code> and <code class="docutils literal notranslate">-</code>),
set operators (such as <code class="docutils literal notranslate">UNION</code>), subquery operators (such as <code class="docutils literal notranslate">ANY</code>), etc.
<div class="toctree-wrapper compound">
</div>
<table class="colwidths-given docutils align-default">
<colgroup>
<col style="width: 35%">
<col style="width: 65%">
</colgroup>
<thead>
<tr class="row-odd"><th class="head">Category</th>
<th class="head">Operators</th>
</tr>
</thead>
<tbody>
<tr class="row-even"><td><a class="reference internal" href="operators-arithmetic.html">Arithmetic Operators</a></td>
<td></td>
</tr>
<tr class="row-odd"><td></td>
<td><code class="code docutils literal notranslate">+</code> , <code class="code docutils literal notranslate">-</code> , <code class="code docutils literal notranslate">*</code> , <code class="code docutils literal notranslate">/</code> , <code class="code docutils literal notranslate">%</code></td>
</tr>
<tr class="row-even"><td><a class="reference internal" href="operators-comparison.html">Comparison Operators</a></td>
<td></td>
</tr>
<tr class="row-odd"><td></td>
<td><code class="code docutils literal notranslate">=</code> , <code class="code docutils literal notranslate">!=</code> , <code class="code docutils literal notranslate">&lt;&gt;</code> , <code class="code docutils literal notranslate">&lt;</code> , <code class="code docutils literal notranslate">&lt;=</code> , <code class="code docutils literal notranslate">&gt;</code> , <code class="code docutils literal notranslate">&gt;=</code></td>
</tr>
<tr class="row-even"><td><a class="reference internal" href="operators-logical.html">Logical/Boolean Operators</a></td>
<td></td>
</tr>
<tr class="row-odd"><td></td>
<td>AND , NOT , OR</td>
</tr>
<tr class="row-even"><td><a class="reference internal" href="operators-query.html">Set Operators</a></td>
<td></td>
</tr>
<tr class="row-odd"><td></td>
<td>INTERSECT, MINUS, EXCEPT, UNION</td>
</tr>
<tr class="row-even"><td><a class="reference internal" href="operators-subquery.html">Subquery Operators</a></td>
<td></td>
</tr>
<tr class="row-odd"><td></td>
<td>[NOT] EXISTS, ANY / ALL, [NOT] IN</td>
</tr>
</tbody>
</table>
</div>

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

Query Operators¶