An aggregation function, as saved: a Group's, and a window's but its rank functions

Enumeration Members

AVERAGE: "Average"
COUNT: "Count"
COUNT_ROWS: "CountRows"

Added by Cube (PLAN §11.5, Q1): every row, null or not, so it takes no column

DISTINCT_COUNT: "DistinctCount"
DISTINCT_VALUE: "DistinctValue"
JOIN_TEXT: "JoinText"

Added in PLAN §11.28: the texts joined by separator, in no set order

MAX: "Max"
MEDIAN: "Median"

Added in PLAN §11.28: the middle value, or the average of the two middle ones

MIN: "Min"
PERCENTILE: "Percentile"

Added in PLAN §11.28: the value percentile of the way through the sorted values, interpolated as Median is

STD_DEV: "StdDev"

Added in PLAN §11.28: the sample standard deviation, over n - 1 values

SUM: "Sum"
VARIANCE: "Variance"

Added in PLAN §11.28: the sample variance, over n - 1 values