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

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.