<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Aggregate Functions > Statistical Variance and Deviation Functions >


Previous pageReturn to chapter overviewNext page

Population Standard Deviation. Returns the returns the square root of the population variance (VAR_POP) for <number expression>, evaluated for each row remaining in the group.

STDDEV_POP ( [DISTINCT | ALL] number-expression )


where ALL includes (and DISTINCT excludes) duplicate values in the input set. ALL is the default. When the the input set has no non-null data, STDDEV_POP returns NULL.

See also sample standard deviation, STDDEV_SAMP, VAR_SAMP, and VAR_POP.