STDEVP

Some parts in the output code are omitted for clarity reasons.

Description

Returns the statistical standard deviation for the population for all values in the specified expression. (STDVEP in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

STDEVP ( [ ALL | DISTINCT ] expression )  

Snowflake SQL

Snowflake SQL Documentation

STDDEV_POP( [ DISTINCT ] expression_1)

Examples

SQL Server

Code:

IN -> SqlServer_01.sql

SELECT
    STDEVP(VACATIONHOURS) AS STDEVP_VACATIONHOURS
FROM
    HumanResources.Employee;

Result:

STDEVP_VACATIONHOURS|
--------------------+
  28.736540767245085|

Snowflake SQL

Code:

OUT -> SqlServer_01.sql

SELECT
    STDDEV_POP(VACATIONHOURS) AS STDEVP_VACATIONHOURS
FROM
    HumanResources.Employee;

Result:

STDEVP_VACATIONHOURS|
--------------------+
        28.736540763|