|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: VARIANCE
Definition:
The Oracle VARIANCE, VAR_POP and VAR_SAMP functions are directly related to their standard deviation counterparts, as standard deviation is simply the square root of the variance. STDDEV and VARIANCE are similar in what they return if there is only one element (both will return a zero). Example Syntax: VARIANCE([DISTINCT | ALL] <value>) OVER (<analytic_clause>) Example Usage: SELECT last_name, salary, Related Links: Related Code Snippets:
|
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |