Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

bitwise OR (|)

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

Syntax

  19 = 10011
  21 = 10101
| -----------
  23 = 10111
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) |
+---------+---------+---------+--------------+
|      23 | 10011   | 10101   | 10111        |
+---------+---------+---------+--------------+