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