STDDEV_POP

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

Syntax

STDDEV_POP(numeric_expression double) ā†’ double

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

Examples

STDDEV_POP example
SELECT STDDEV_POP(gas_used) 
FROM eth.recent_blocks
-- 2.259665030506379

STDDEV_POP(numeric_expression float) ā†’ double

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

Examples

STDDEV_POP example
SELECT STDDEV_POP(gas_used) 
FROM eth.recent_blocks
-- 2.259665030506379

STDDEV_POP(numeric_expression int32) ā†’ double

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

Examples

STDDEV_POP example
SELECT STDDEV_POP(transaction_count) 
FROM eth.recent_blocks
-- 1.367021462155777

STDDEV_POP(numeric_expression int64) ā†’ double

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

Examples

STDDEV_POP example
SELECT STDDEV_POP(transaction_count) 
FROM eth.recent_blocks
-- 1.367021462155777

Last updated