Definition:
The Oracle VAR_SAMP function returns the sample variance of a set of numbers after discarding any NULLS in the set.
The VAR_SAMP function takes as an argument any numeric datatype (or any non-numeric datatype that can be implicitly converted to a numeric datatype). The function returns the same datatype as the numeric datatype of the argument.
Example Syntax:
VAR_SAMP(<value>) OVER (<analytic_clause>);
Related Links:
Related Code Snippets:
- COVAR_SAMP - COVAR_SAMP returns the sample covariance of a set of number pairs. Both expr1 and exp...
