Aggregate FunctionsStatistical

binary_all_or

Returns the bitwise OR of every non-null value in the group, or null for a group without one.

Syntax

binary_all_or(val)

Prop

Type

Returns: long

binary_all_or(val)

Prop

Type

Returns: int

datatable(num:long)[
  2290647048,
  1107296256,
  7761920,
  5
]
| summarize result = toupper(tohex(binary_all_or(num)))

result (string)
CAFEF00D

binary_all_and

Returns the bitwise AND of every non-null value in the group, or null for a group without one.

binary_all_xor

Returns the bitwise XOR of every non-null value in the group, or null for a group without one.