STDDEV_POP

<< Click to Display Table of Contents >>

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

STDDEV_POP

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.