VARIANCE_POP
Learn how to use the VARIANCE_POP aggregate function in PlaidCloud Lakehouse. Returns the population variance - see syntax, examples, and output.
Returns the population variance.
Analyze Syntax
func.variance_pop(get_column(table, 'score'))
Analyze Examples
func.variance_pop(get_column(table, 'score'))
┌────────┐
│ 234.72 │
└────────┘
SQL Syntax
VARIANCE_POP(<score>)
SQL Examples
SELECT VARIANCE_POP(score) FROM test_results;
┌────────┐
│ 234.72 │
└────────┘