Dremio Cloud
Dremio Software
 
On this page

    Categories: Math, Aggregate

    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(tip_amount) FROM Samples."samples.dremio.com"."NYC-taxi-trips"
-- 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(tip_amount) FROM Samples."samples.dremio.com"."NYC-taxi-trips"
-- 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(passenger_count) FROM Samples."samples.dremio.com"."NYC-taxi-trips"
-- 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(passenger_count) FROM Samples."samples.dremio.com"."NYC-taxi-trips"
-- 1.367021462155777