Description
Returns the statistical variance of all values in the specified expression. ().
Sample Source Pattern
Syntax
VAR ( [ ALL | DISTINCT ] expression )
VAR_SAMP( [DISTINCT] <expr1> )
Examples
Code:
SELECT
VAR(VACATIONHOURS)
FROM
HUMANRESOURCES.EMPLOYEE AS VAR;
Result:
VAR|
----------------+
28.7862150320948|
Code:
SELECT
VAR_SAMP(VACATIONHOURS)
FROM
HUMANRESOURCES.EMPLOYEE AS VAR;
Result:
VAR|
----------+
828.646176|