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

Examples

SQL Server

Code:

	SELECT STDEVP(VACATIONHOURS) AS STDEVP_VACATIONHOURS FROM HumanResources.Employee 

Result:

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

Snowflake SQL