STDDEV_POP [Aggregate]
Evaluates the statistical population standard deviation for each member of the group.
Behavior Type
Syntax
STDDEV_POP ( expression )
Parameters
expression |
Any |
Related Functions
- This function differs from the analytic function
STDDEV_POP
, which evaluates the statistical population standard deviation for each member of the group of rows within a window. -
STDDEV_POP
returns the same value as the square root ofVAR_POP
:STDDEV_POP(
expression) = SQRT(VAR_POP(
expression))
- When
VAR_SAMP
returnsNULL
, this function returnsNULL
.
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)