Var
Aggregation
Var(column)
SQL VARIANCE over the current context.
When to use it
Section titled “When to use it”- Statistical inputs where variance itself is the quantity — otherwise
Stdevreads more naturally (same units as the data).
Good to know
Section titled “Good to know”- Non-additive — rejected under
YTD/RollingSum(SQX015).