VARIANCE_SAMP

VARIANCE_SAMP

Compute the variance for a column/group/window with N - 1 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.