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

Examples

SQL Server

Code:

IN -> SqlServer_01.sql

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

Result:

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

Snowflake SQL