STDDEV_SAMP

Learn how to use the STDDEV_SAMP aggregate function in PlaidCloud Lakehouse. Returns the sample standard deviation - see syntax, examples, and output.

Returns the sample standard deviation.

Analyze Syntax

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

Analyze Examples

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

┌───────┐
│ 15.89 │
└───────┘

SQL Syntax

STDDEV_SAMP(<score>)

SQL Examples

SELECT STDDEV_SAMP(score) FROM test_results;

┌───────┐
│ 15.89 │
└───────┘