bitwise AND (&)

Combines two integers to produce a third integer whose binary bits are 1 if and only if both bits in the input numbers are also 1.

Syntax

  19 = 10011
  21 = 10101
& -----------
  17 = 10001
num1 & num2

Return Type

Integer

Examples

SELECT 19 & 21, bin(19), bin(21), bin(19 & 21);
+---------+---------+---------+--------------+
| 19 & 21 | bin(19) | bin(21) | bin(19 & 21) |
+---------+---------+---------+--------------+
|      17 | 10011   | 10101   | 10001        |
+---------+---------+---------+--------------+

Last modified: February 24, 2023

Was this article helpful?