VARIANCE (Lakehouse v2)

Returns the population variance. Alias for VARIANCE_POP.

Analyze Syntax

func.variance(get_column(table, 'score'))

Analyze Examples

func.variance(get_column(table, 'score'))

┌────────┐
│ 234.72 │
└────────┘

SQL Syntax

VARIANCE(<score>)

SQL Examples

SELECT VARIANCE(score) FROM test_results;

┌────────┐
│ 234.72 │
└────────┘