& (ampersand sign) operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the bitwise AND 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 widest type of expr1 and expr2.

Examples

> SELECT 3 & 5;
 1