Skip to main content

STDEV

Returns the statistical standard deviation of all values in the specified expression.

Syntax

STDEV ( [ DISTINCT ] expression  )  

Arguments

expression
An expression of numeric data type category.

DISTINCT Specifies that each unique value is considered.

Return Type

Returns a FLOAT64.

Examples

This example returns the standard deviation for all prices in the pricing blockchain.

SELECT STDEV(price) FROM pricing;

Response:

STDEV(PRICE) [FLOAT64]  
48.77039856063321