ARRAY_STDDEV_SAMP()

All functions > ARRAY > ARRAY_STDDEV_SAMP()

Returns the sample standard deviation (divide by N-1) of numeric array elements as a DOUBLE.

Signatures

Returns: Sample standard deviation

ARRAY_STDDEV_SAMP(array: ARRAY<T>) → DOUBLE

Notes

• Ignores NULL elements
• Returns NULL when fewer than two non-NULL values are present

See also

• Array functions

Examples

SELECT
    -- Sample stddev
    f1 := ROUND(ARRAY_STDDEV_SAMP(ARRAY(2, 4, 4, 4, 5, 5, 7, 9)), 3)
;