Skip to main content
Skip to main content

stddevSamp

The result is equal to the square root of varSamp.

Alias: STDDEV_SAMP.

note

This function uses a numerically unstable algorithm. If you need numerical stability in calculations, use the stddevSampStable function. It works slower but provides a lower computational error.

Syntax

Parameters

Returned value

Square root of sample variance of x. Float64.

Example

Query:

Result:

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free