Description
Returns the statistical standard deviation of all values in the specified expression. ().
Sample Source Pattern
Syntax
STDEV ( [ ALL | DISTINCT ] expression )
STDDEV( [ DISTINCT ] <expression_1> )
Examples
Code:
SELECT
STDEV(VACATIONHOURS)
FROM
HUMANRESOURCES.EMPLOYEE AS STDEV;
Result:
STDEV|
----------------+
28.7862150320948|
Code:
SELECT
STDDEV(VACATIONHOURS)
FROM
HUMANRESOURCES.EMPLOYEE AS STDEV;
Result:
STDEV|
------------+
28.786215034|