Skip to content

STDDEV_POP and STDDEV_SAMP

STDDEV_POP computes population standard deviation; STDDEV_SAMP uses the sample form. Both accept ALL/DISTINCT and omit null inputs.

FOR value IN [10, 20, 30]
RETURN STDDEV_POP(value) AS population, STDDEV_SAMP(value) AS sample;

These are numeric aggregates with floating results. Insufficient input for a sample estimate produces null. Empty input produces null, and non-finite aggregate results are errors. See aggregate behavior.