STDDEV_POP [Aggregate]

Evaluates the statistical population standard deviation for each member of the group.

Behavior Type

Immutable

Syntax

STDDEV_POP ( expression )

Parameters

expression

Any NUMERIC data type or any non-numeric data type that can be implicitly converted to a numeric data type. STDDEV_POP returns the same data type as expression.

Related Functions

Examples

The following example returns the statistical population standard deviation for each household ID in the customer table.

=> SELECT STDDEV_POP(household_id) FROM customer_dimension;
   STDDEV_POP    
------------------
 8651.41895973367
(1 row)