VAR_SAMP
Returns the sample variance of non-NULL records.
Syntax
VAR_SAMP(numeric_expression int64) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_SAMP(transaction_count)
FROM eth.recent_blocks
-- 1.868747683518558
VAR_SAMP(numeric_expression float) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_SAMP(gas_used)
FROM eth.recent_blocks
-- 5.106086065187043
VAR_SAMP(numeric_expression double) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_SAMP(gas_used)
FROM eth.recent_blocks
-- 5.106086065187043
VAR_SAMP(numeric_expression int32) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_SAMP(transaction_count)
FROM eth.recent_blocks
-- 1.868747683518558
Usage Notes
For single input records, VAR_SAMP will return NULL.
Last updated
Was this helpful?