STDDEV Function

Description

The STDDEV function calculates the standard deviation of a given expression.

Syntax

STDDEV( [DISTINCT | UNIQUE | ALL] expression )

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

Example

The following is an example that returns the standard deviation of the number of gold medals that Korea won in the Olympic Games from 1988 to 2004.

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

Result : 2