Name
VAR — Returns the variance.
Synopsis
numeric
VAR
(
|
in
expr
any
); |
Description
VAR (VARIANCE) returns variance of expr. Virtuoso calculates the variance of expr as follows: 0 if the number of rows in expr = 1; VAR_SAMP if the number of rows in expr > 1
Parameters
expr
Number expression.
Return Types
The function returns a value of type NUMERIC. If the function is applied to an empty set, then it returns null.