STDEVP

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:

	SELECT STDEVP(VACATIONHOURS) AS STDEVP_VACATIONHOURS FROM HumanResources.Employee 

Result:

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

Snowflake SQL

Code:

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

Result:

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