Description: VAR_POP returns the population variance of a set of numbers after discarding the nulls in this set. The expr is a number expression, and the function returns a value of type NUMERIC. If the function is applied to an empty set, then it returns null. The function makes the following calculation:
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
VAR_POP(<value>) OVER (<analytic_clause>)
OVER (ORDERBY t.calendar_month_desc)"Var_Pop",VAR_SAMP(SUM(s.amount_sold))
OVER (ORDERBY t.calendar_month_desc)"Var_Samp"FROM sales s, times t
WHERE s.time_id = t.time_id AND t.calendar_year =2001GROUPBY t.calendar_month_desc;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.