Name

STDDEV_SAMP — Returns the cumulative sample standard deviation.

Synopsis

numeric STDDEV_SAMP ( in expr any );

Description

STDDEV_SAMP computes the cumulative sample standard deviation and returns the square root of the sample variance. The expr is a numeric expression, and the function returns a value of type NUMERIC. This function is same as the square root of the VAR_SAMP function. When VAR_SAMP returns null, this function returns null.

Parameters

expr

Number expression.

Return Types

The function returns a value of type NUMERIC. If the function is applied to an empty set, then it returns null.