stddev_samp

relationalai.semantics.std.aggregates

stddev_samp(*args: AggValue) -> Aggregate

Compute the sample standard deviation of values.

Parameters

• *args

  (AggValue, default: ()) - Values to compute sample standard deviation over. Can include Distinct wrapper for distinct aggregation.

Returns

• Aggregate - An Aggregate representing the computation of the sample standard deviation. Always returns Float.

Examples

Compute sample standard deviation of salaries:

select(aggregates.stddev_samp(Employee.salary))

Compute sample standard deviation of salaries per department:

select(Department, aggregates.stddev_samp(Employee.salary).per(Department))