# stddevPopStable (/docs/reference/sql/aggregate-functions/stddevpopstable)



This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See [SQL interface scope](/docs/reference/clickhouse-compatibility#service-interfaces).

The result is equal to the square root of [varPop](/reference/functions/aggregate-functions/varPop). Unlike [stddevPop](/reference/functions/aggregate-functions/stddevPop), this function uses a numerically stable algorithm. It works slower but provides a lower computational error.

**Syntax**

```sql
stddevPopStable(x)
```

**Arguments**

* `x` — Population of values to find the standard deviation of. [`(U)Int*`](/reference/data-types/int-uint) or [`Float*`](/reference/data-types/float) or [`Decimal*`](/reference/data-types/decimal)

**Returned value**

Returns the square root of the variance of `x`. [`Float64`](/reference/data-types/float)

**Examples**

**Basic usage**

```sql title=Query
DROP TABLE IF EXISTS test_data;
CREATE TABLE test_data
(
    population Float64,
)
ENGINE = Log;

INSERT INTO test_data SELECT randUniform(5.5, 10) FROM numbers(1000000);

SELECT
    stddevPopStable(population) AS stddev
FROM test_data;
```

```text title=Response
┌─────────────stddev─┐
│ 1.2999977786592576 │
└────────────────────┘
```

*Introduced in version 1.1.0.*
