Aggregate FunctionsStatistical

binary_all_xor

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

Syntax

binary_all_xor(val)

Prop

Type

Returns: long

binary_all_xor(val)

Prop

Type

Returns: int

datatable(num:long)[
  1145062464,
  505290270,
  2427173385,
  725082
]
| summarize result = toupper(tohex(binary_all_xor(num)))

result (string)
CAFEF00D

binary_all_or

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

count

Returns a count of the records in the input record set.