DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Status

Reference

  1. Overview
    • SQL Command Reference
      • Query Syntax
        • Query Operators
          • Arithmetic
            • Comparison
              • Logical
                • Set Operators
                  • Subquery
                  • General DDL
                    • General DML
                      • All Commands (Alphabetical)
                        • Accounts
                          • Users, Roles, & Privileges
                            • Integrations
                              • Replication & Failover
                                • Sessions
                                  • Transactions
                                    • Virtual Warehouses & Resource Monitors
                                      • Databases, Schemas, & Shares
                                        • Tables, Views, & Sequences
                                          • Functions, Procedures, & Scripting
                                            • Streams & Tasks
                                              • Classes & Instances
                                                • Security
                                                  • Data Governance
                                                    • Data Loading & Unloading
                                                      • File Staging
                                                        • Alerts
                                                          • Native Apps Framework
                                                            • Streamlit
                                                            • Function Reference
                                                              • Class Reference
                                                                • Scripting Reference
                                                                  • General Reference
                                                                    • API Reference
                                                                      ReferenceSQL Command ReferenceQuery 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

                                                                      See also Bitwise Expression Functions.

                                                                      Was this page helpful?

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