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

STDEVP ( [ ALL | DISTINCT ] expression )  

Examples

Code:

IN -> SqlServer_01.sql
SELECT
    STDEVP(VACATIONHOURS) AS STDEVP_VACATIONHOURS
FROM
    HumanResources.Employee;

Result:

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

Known Issues

No issues were found.

No related EWIs.

Last updated