<=>
(lt eq gt sign) operator
Applies to: Databricks SQL Databricks Runtime
Returns the same result as the EQUAL(=)
for non-null operands, but returns true
if both are NULL
, false
if one of the them is NULL
. This operator is a synonym for expr1 is not distinct from expr2
.
Syntax
expr1 <=> expr2
Arguments
expr1
: An expression of a comparable type.expr2
: An expression that shares a least common type withexpr1
.
Returns
A BOOLEAN.
Examples
> SELECT 2 <=> 2;
true
> SELECT 1 <=> '1';
true
> SELECT true <=> NULL;
false
> SELECT NULL <=> NULL;
true