Snowflake, Inc.
|
DOCUMENTATION
  • Snowflake Summit
  • Community
  • Resources
  • Blog
      • LANGUAGES:
      • English
      • Deutsch
      • Français
      • 日本語
      • 한국어
  • 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 Organization
  • Managing Your Snowflake Account
  • Managing Security in Snowflake
  • Managing Governance in Snowflake
  • Managing Cost in Snowflake
  • Developing Applications with 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
  • Snowflake Scripting Reference
  • API Reference
  • Appendices
  • Snowflake Summit 2022: User Conference
Next Previous |
  • Docs »
  • SQL Command Reference »
  • Query Operators »
  • Comparison Operators

Comparison Operators¶

.

Related Topics

  • Numeric Data Types

  • String & Binary Data Types

  • Conditional Expression Functions

Comparison operators are used to test the equality of two input expressions. They are typically used in the WHERE clause of a query.

Operator

Syntax

Description

=

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.

Next Previous |
  • Ask the Community
  • Contact Support
  • Report Doc Issue
Snowflake Inc.
  • Platform
    • Cloud Data Platform
    • Architecture
    • Pricing
    • Data Marketplace
  • Solutions
    • Snowflake for Healthcare & Life Sciences
    • Snowflake for Marketing Analytics
    • Snowflake for Retail
    • Snowflake for Education
    • Snowflake for Developers
  • Resources
    • Resource Library
    • Webinars
    • Community
    • Legal
  • Explore
    • News
    • Blog
    • Trending
  • About
    • About Snowflake
    • Leadership & Board
    • Careers
    • Contact
  • Privacy Notice
  • Site Terms

© 2022 Snowflake Inc. All Rights Reserved