Book Contents

Book Index

Next Topic

Home

VAR_POP

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 column reference

Examples

SELECT VAR_POP(b) FROM aggtest;

var_pop

------------------

4107273296.58857

(1 row)