STDDEV_POP evaluates the statistical population variance for each member of the group. This is defined as the sum of squares of the difference of expression from the mean of expression, divided by the number of rows remaining.
Syntax
STDEV_POP ( expression )
Semantics
expression |
(INTEGER, BIGINT, DOUBLE PRECISION, or INTERVAL) contains at least one |
Examples
SELECT VAR_POP(b) FROM aggtest;
var_pop
------------------
4107273296.58857
(1 row)