Built-In Functions and Syntax › Standard deviation

Standard deviation

Returns the standard deviation of the values in column-name (the square root of the average differences between the values and their arithmetic mean).

The standard deviation function uses the n-1 method (sample standard deviation).

This function calculates standard deviation using the formula shown below:

Syntax:

►►─── STD ── (column-name) ───────────────────────────────────────────────────►◄

Invocation names:

STD

Parameters:

column-name

Specifies the list of values on which the standard deviation is calculated.

Example:

This example displays all rows where the standard deviation of SALARY is greater than $5,000:

select std(salary) as 'SALARY STAND-DEV' from employee
group by dept-id having std(salary) > 5000