Snowflake supports most of the standard operators defined in SQL:1999.

**Arithmetic Operators**

+ , – , * , / , %

+ (unary) | +a | Returns a, which will cause implicit conversion of a to a numeric value. If a is a string, but the string cannot be converted to a numeric value, an error is returned. |

+ | a + b | Adds two numeric expressions (a and b). |

– (unary) | -a | Negates the input numeric expression. |

– | a – b | Subtracts one numeric expression (b) from another (a). |

– | a – b | Subtracts one date expression (b) from another (a). The result is an integer number of days. Subtraction is the only arithmetic operation allowed on DATE expressions. |

* | a * b | Multiplies two numeric expressions (a and b). |

/ | a / b | Divides one numeric expression (a) by another (b). |

% | a % b | Computes the modulo of numeric expression a per b. See also MOD. |

**Comparison Operators**

= , != , <> , < , <= , > , >=

= | a = b | a is equal to b. |

!= | a != b | a is not equal to b. |

<> | a <> b | a is not equal to b. |

> | a > b | a is greater than b. |

>= | a >= b | a is greater than or equal to b. |

< | a < b | a is less than b. |

<= | a <= b | a is less than or equal to b |

**Logical/Boolean Operators**

AND , NOT , OR

`<span class="pre">AND</span>` |
`<span class="pre">a</span> <span class="pre">AND</span> <span class="pre">b</span>` |
Matches both expressions (`<em><span class="pre">a</span></em>` and `<em><span class="pre">b</span></em>` ). |

`<span class="pre">NOT</span>` |
`<span class="pre">NOT</span> <span class="pre">a</span>` |
Does not match the expression. |

`<span class="pre">OR</span>` |
`<span class="pre">a</span> <span class="pre">OR</span> <span class="pre">b</span>` |
Matches either expression. |

**Set Operators**

INTERSECT, MINUS, EXCEPT, UNION

**Subquery Operators**

[NOT] EXISTS, ANY / ALL, [NOT] IN