Built-In Functions and Syntax › Variance population

Variance population

Returns the variance population of the values in column-name (the square of the standard deviation population).

The variance population function uses the n, absolute, method.

This function calculates variance using the formula shown below:

Syntax:

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

Invocation names:

VARP

Parameters:

column-name

Specifies the list of values on which the variance population is calculated.

Example:

The variance function in this example displays the variance population between the rows in SALARY-MANAGER:

select varp(salary-manager) as 'SALARY VARP'
  from employee group by job-id