Book Contents

Book Index

Next Topic

Home

STDDEV_POP

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

Examples

SELECT STDDEV_POP(b) FROM aggtest;

stddev_pop

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

64088.0121129418

(1 row)