VAR

Description

VAR calculates the variance per group. The variance is the square root of the standard deviation. Variance can be applied to INT or FLOAT columns.

VAR ( table.column )

NULL values are ignored, so they do not influence the result. If all the values of a group are NULL, the result for this group is also NULL.

[1]

Variance of column.

Query

Column1

VAR ( "Table"."Column" )

Input

Output

Table

Result

Column1 : float
1.0

[2]

Variance by country.

Query

Column1

"Table"."Country"

Column2

VAR ( "Table"."Values" )

Input

Output

Table

Result

[3]

Variance with nulls, grouped by country.

Query

Column1

"Table"."Country"

Column2

VAR ( "Table"."Values" )

Input

Output

Table

Result

Column1 : string	Column2 : float
'DE'	null
'FR'	0.0