Built-In Functions and Syntax › Standard deviation population

Standard deviation population

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

The standard deviation population (STDP) function uses the n method (absolute standard deviation).

This function calculates standard deviation using the formula shown below:

Syntax:

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

Invocation names:

STDP

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 population of SALARY is greater than $5,000:

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