STDDEV_POP evaluates the statistical population standard deviation for each member of the group.
STDDEV_POP(expression) = SQRT(VAR_POP(expression))
Syntax
STDDEV_POP ( expression )
Semantics
expression |
(INTEGER, BIGINT, DOUBLE PRECISION, or INTERVAL) contains at least one |
Examples
SELECT STDDEV_POP(b) FROM aggtest;
stddev_pop
------------------
64088.0121129418
(1 row)