Reference Guide
>
TDV Support for SQL Functions
>
Aggregate Functions
>
VARIANCE
VARIANCE
VARIANCE returns the variance of expression.
Syntax
VARIANCE ( [DISTINCT | ALL ] expression) OVER (window_clause)
Remarks
•
Without a window clause, VARIANCE is a simple aggregate function.