^
(caret sign) operator
Applies to: Databricks SQL
Databricks Runtime
Returns the bitwise exclusive OR (XOR)
of expr1
and expr2
.
expr1 ^ expr2
expr1
: An integral numeric type expression.expr2
: An integral numeric type expression.
The result type matches the least common type of expr1
and expr2
.
> SELECT 3 ^ 5;
6