VAR_SAMP

Learn how to use the VAR_SAMP aggregate function in PlaidCloud Lakehouse. Returns the sample variance. Alias for VARIANCE_SAMP - with syntax and examples.

Returns the sample variance. Alias for VARIANCE_SAMP.

Analyze Syntax

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

Analyze Examples

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

┌────────┐
│ 252.48 │
└────────┘

SQL Syntax

VAR_SAMP(<score>)

SQL Examples

SELECT VAR_SAMP(score) FROM test_results;

┌────────┐
│ 252.48 │
└────────┘