STDEVP

Applies to

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. ().

STDEVP ( [ ALL | DISTINCT ] expression )

STDDEV_POP( [ DISTINCT ] expression_1)

Code:

IN -> SqlServer_01.sql

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

Result:

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

Code:

OUT -> SqlServer_01.sql

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

Result:

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

No issues were found.

No related EWIs.

Last updated 2 months ago