Stddev_Samp

This function calculates the cumulative sample standard deviation. It uses the following formula: SQRT(Var_Samp(X)).

Syntax:

Stddev_Samp(Expression)

Parameter:

Expression. Type: Number. 

Return value: Number.

Example:

X	Y
1	7
2	1
3	2
4	5
5	7
6	34
7	32
8	43
9	87

SELECT Stddev_Samp(Y) FROM Table

Result:

28.3847573

Next page: Var_Samp