Snowflake
Getting Started
Guides
Developer
Reference
Releases
Status
Ctrl+K

Reference

  1. Overview
  2. SQL Command Reference
    1. Query Syntax
    2. Query Operators
      1. Arithmetic
      2. Comparison
      3. Logical
      4. Set Operators
      5. Subquery
    3. General DDL
    4. General DML
    5. All Commands (Alphabetical)
    6. Accounts
    7. Users, Roles, & Privileges
    8. Integrations
    9. Security Policies
    10. Replication & Failover
    11. Sessions
    12. Transactions
    13. Virtual Warehouses & Resource Monitors
    14. Databases, Schemas, & Shares
    15. Tables, Views, & Sequences
    16. Functions, Procedures, & Scripting
    17. Streams & Tasks
    18. Data Governance
    19. Secret
    20. Data Loading & Unloading
    21. File Staging
    22. Alerts
  3. Function Reference
  4. Scripting Reference
  5. General Reference
  6. API Reference

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

Was this page helpful?

Visit Snowflake
Having problems? Get support
Join the conversation in our community
Read the latest on our blog
Develop with Snowflake
Get your Snowflake certification
Privacy NoticeSite Terms© 2023 Snowflake, Inc. All Rights Reserved.
Language: English
English
Français
Deutsch
日本語
한국어
Português