Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
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