Skip to content

VARIANCE_POP

VARIANCE_POP

Compute the variance for a column/group/window with N degrees of freedom. Supported on numeric types.

Returns NULL if the input is all NULL or empty.

Note

When used as a window function with an ORDER BY clause but no window frame, ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW is used by default.