Quick Search:
 
 The Oracle VAR_SAMP Function      [Return To Index] Jump to:  

Term: VAR_SAMP

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...
  • VAR_SAMP - VAR_SAMP returns the sample variance of a set of numbers after discarding the nulls in ...
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org