VARIANCE Function

Description

The VARIANCE function calculates the variance of a given expression using the following formula:

Syntax

VARIANCE( [DISTINCT | UNIQUE | ALL] expression )

• expression : Specifies the expression to calculate the variance.
• ALL : Gets the variance of all values (default).
• DISTINCT or UNIQUE : Gets the variance of unique values without duplicates.

Example

The following is an example that returns the variance of the number of gold medals that Korea won.

SELECT VARIANCE(gold)
FROM participant
WHERE nation_code = 'KOR';

Result : 5