Skip to main content

AggregateFunction

  • Namespace: PPDS.Dataverse.Query.Planning.Nodes
  • Assembly: PPDS.Dataverse
  • Kind: Enum
  • Implements: IComparable, IConvertible, IFormattable, ISpanFormattable

Summary​

Aggregate functions supported by MergeAggregateNode. Note: COUNT(DISTINCT) is NOT supported for parallel partitioning because summing partial distinct counts would double-count values appearing in multiple partitions. Use a single-partition approach for COUNT(DISTINCT).

Members​

Fields​

Avg​

AggregateFunction Avg

Computes the average of values.

Count​

AggregateFunction Count

Counts the number of rows.

Max​

AggregateFunction Max

Finds the maximum value.

Min​

AggregateFunction Min

Finds the minimum value.

Stdev​

AggregateFunction Stdev

Computes standard deviation (client-side).

StdevP​

AggregateFunction StdevP

Computes population standard deviation (client-side).

StringAgg​

AggregateFunction StringAgg

Concatenates values with separator (client-side).

Sum​

AggregateFunction Sum

Computes the sum of values.

Var​

AggregateFunction Var

Computes variance (client-side).

VarP​

AggregateFunction VarP

Computes population variance (client-side).