Skip to content

stddev_samp

Returns the sample standard deviation (square root of sample variance) of non-NULL values.

See also STDDEV_POP, which returns the population standard deviation (square root of variance).

stddev_samp ( <expr> )

An expression that evaluates to a numeric value. This is the expression on which the standard deviation is calculated.

The data type of the returned value is float.

If all records inside a group are NULL, this function returns NULL.

ScopeDB Logo ScopeDB
© 2025 ScopeDB. All rights reserved.