Snowflake, Inc.
  • Community
  • Resources
  • Blog
  • Getting Started
  • Introduction to Snowflake
  • Tutorials, Videos & Other Resources
  • Release Notes
  • Connecting to Snowflake
  • Loading Data into Snowflake
  • Unloading Data from Snowflake
  • Using Snowflake
  • Sharing Data Securely in Snowflake
  • Managing Your Snowflake Account
  • Managing Security in Snowflake
  • General Reference
  • SQL Command Reference
    • Summary of Commands
    • All Commands (Alphabetical)
    • DDL Commands
    • DML Commands
    • Query Syntax
    • Query Operators
      • Arithmetic Operators
      • Comparison Operators
      • Logical/Boolean Operators
      • Set Operators
      • Subquery Operators
  • SQL Function Reference
  • Appendices
Next Previous |
  • Docs »
  • SQL Command Reference »
  • Query Operators

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

Next Previous |
  • Ask the Community
  • Contact Support
  • Report Doc Issue
Snowflake, Inc.

follow us

visit our blog

  • Solutions

    • Use Cases
    • Media & Entertainment
    • Healthcare
    • Financial Services
    • Retail & Consumer Goods
  • Products

    • Overview
    • Why Snowflake
    • Architecture
    • Data Warehouse Security
    • Pricing
  • Resources

    • Resource Library
    • Support & Services
    • Documentation
    • Legal
    • Community
  • Explore

    • Customers
    • News
    • Events
    • Webinars
    • Blog
  • About

    • About Snowflake
    • Partners
    • Leadership
    • Board
    • Careers
    • Contact
  • Product
  • Customers
  • Pricing
  • Partners
  • Use Cases
  • About Us
  • Resources
  • Contact Us
  • Blog

450 Concar Drive, San Mateo, CA, 94402, United States | 844-SNOWFLK (844-766-9355)

© 2019 Snowflake Inc. All Rights Reserved | Privacy | Site Terms