Snowflake logo
Getting Started
Guides
Developer
Reference
Releases
Status
Ctrl+K

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
                              • Security Policies
                                • Replication & Failover
                                  • Sessions
                                    • Transactions
                                      • Virtual Warehouses & Resource Monitors
                                        • Databases, Schemas, & Shares
                                          • Tables, Views, & Sequences
                                            • Functions, Procedures, & Scripting
                                              • Streams & Tasks
                                                • Data Governance
                                                  • Secret
                                                    • Data Loading & Unloading
                                                      • File Staging
                                                        • Alerts
                                                        • Function 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

                                                                Was this page helpful?

                                                                Snowflake logo
                                                                Visit Snowflake
                                                                Have feedback? Let us know
                                                                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