ReferenceSQL ReferenceAggregate Functions

skewPop

Computes the [skewness](https://en.

Computes the skewness of a sequence.

Syntax

skewPop(expr)

Arguments

  • expr — An expression returning a number. Expression

Returned value

Returns the skewness of the given distribution. Float64

Examples

Symmetric distribution

SELECT skewPop(number) FROM numbers(100);
┌─skewPop(number)─┐
│               0 │
└─────────────────┘

Right-skewed distribution

SELECT skewPop(x) FROM (SELECT pow(number, 2) AS x FROM numbers(10));
┌─────────skewPop(x)─┐
│ 0.6735701055423582 │
└────────────────────┘

Introduced in version 20.1.

singleValueOrNull

The aggregate function singleValueOrNull is used to implement subquery operators, such as `x = ALL (SELECT.

skewSamp

Computes the [sample skewness](https://en.