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