STDDEV

Returns the standard deviation of non-NULL values in a column with a numeric data type. If all records inside a group are NULL, returns NULL.

Syntax

STDDEV(numeric_expression double) → double

  • numeric_expression: The set of records to calculate the standard deviation for.

Examples

STDDEV example
SELECT STDDEV(gas_used) 
FROM eth.recent_blocks
-- 2.2596650338461766

STDDEV(numeric_expression float) → double

  • numeric_expression: The set of records to calculate the standard deviation for.

Examples

STDDEV example
SELECT STDDEV(gas_used) 
FROM eth.recent_blocks
-- 2.2596650338461766

STDDEV(numeric_expression int32) → double

  • numeric_expression: The set of records to calculate the standard deviation for.

Examples

STDDEV example
SELECT STDDEV(transaction_count) 
FROM eth.recent_blocks
-- 1.3670214641762426

STDDEV(numeric_expression int64) → double

  • numeric_expression: The set of records to calculate the standard deviation for.

Examples

STDDEV example
SELECT STDDEV(transaction_count) 
FROM eth.recent_blocks
-- 1.3670214641762426

Last updated