Practice: Using Bitwise Aggregate Functions
Overview
This practice shows how to use the new BIT_AND_AGG
, BIT_OR_AGG
and BIT_XOR_AGG
bitwise aggregate functions at the bit level of records within a group. BIT_AND_AGG
, BIT_OR_AGG
and BIT_XOR_AGG
return the result of bitwise AND, OR and XOR operations respectively. These aggregates can be performed on a single numeric column or an expression. The return type of a bitwise aggregate operation is always a number.
Before starting any new practice, refer to the Practices Environment recommendations.
Step 1 : Test the bitwise AND function

Connect to
PDB21
asSYSTEM
to query values with numbers and bitwise aggregate functions. 
A bitwise AND is a binary operation that takes two equallength binary representations and performs the logical AND operation on each pair of the corresponding bits. If both bits in the compared position are 1, the bit in the resulting binary representation is 1, otherwise, the result is 0. Apply the
BIT_AND_AGG
function on two numbers. The bit pattern for the values used in the examples below are 01 for 1, 10 for 2, and 11 for 3.
Step 2 : Test the bitwise OR function
A bitwise OR is a binary operation that takes two bit patterns of equal length and performs the logical inclusive OR operation on each pair of corresponding bits. The result in each position is 0 if both bits are 0, otherwise the result is 1.
 Apply the
BIT_OR_AGG
function on two numbers.
Step 3 : Test the bitwise XOR function
A bitwise XOR is a binary operation that takes two bit patterns of equal length and performs the logical exclusive OR operation on each pair of corresponding bits. The result in each position is 1 if only the first bit is 1 or only the second bit is 1, but will be 0 if both are 0 or both are 1. Therefore, the comparison of two bits results in 1 if the two bits are different, and 0 if they are equal.
 Apply the
BIT_XOR_AGG
function on two numbers.