• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. Functions and Operators
  6. Comparison Operators

Comparison Operators

Comparison operators are available for all data types and return Boolean values.

All comparison operators are binary operators. Only data types that are the same or can be implicitly converted can be compared using comparison operators.

Table 1 describes comparison operators provided by DWS.

Table 1 Comparison Operators

Operators

Description

<

Smaller

>

Greater than

<=

Smaller or equal

>=

Larger or equal

=

Equal to

<> or !=

Unequal

Comparison operators are available for all relevant data types. All comparison operators are binary operators that returned values of Boolean type. Expressions like 1 < 2 < 3 are invalid. (Because there is no comparison operator to compare a Boolean value with 3.)