groupBitAnd

Applies bitwise AND for series of numbers.

  1. groupBitAnd(expr)

Parameters

expr – An expression that results in UInt* type.

Return value

Value of the UInt* type.

Example

Test data:

  1. binary     decimal
  2. 00101100 = 44
  3. 00011100 = 28
  4. 00001101 = 13
  5. 01010101 = 85

Query:

  1. SELECT groupBitAnd(num) FROM t

Where num is the column with the test data.

Result:

  1. binary     decimal
  2. 00000100 = 4