This practice shows how to use the new
BIT_XOR_AGG bitwise aggregate functions at the bit level of records within a group.
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
SYSTEMto query values with numbers and bitwise aggregate functions.
A bitwise AND is a binary operation that takes two equal-length 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_AGGfunction 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_AGGfunction 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_AGGfunction on two numbers.