stddev_pop

Computes the standard deviation of a population consisting of a numeric expression, as a double. stdevp is an alias for stddev_pop, and uses the same syntax.

Syntax

stddev_pop ( [ all | distinct ] expression )

Parameters

Examples

Usage

Computes the population standard deviation of the provided value expression evaluated for each row of the group (if distinct was specified, then each row that remains after duplicates have been eliminated), defined as the square root of the population variance.

Formula for Population-Related Statistical Aggregate Functions
The formula for population-related statistical aggregate functions.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute stddev_pop.

Related reference
stddev_samp
var_pop
var_samp