bitwise OR (|)
On this page
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 = 10111num1 | num2Return 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 |
+---------+---------+---------+--------------+Last modified: February 24, 2023