|
|
|
VARP windowing function
Declaration
VARP ( { expression } ) OVER ( [ partition_by_clause ] order_by_clause )
Description
VARP Returns the statistical variance for the population for all values in the specified expression. Use VARP when you have every data point for the population available. Otherwise, use the generic VAR for the sample.
• The argument numeric_expression can be of any numeric type except BIT. Aggregate functions and subqueries are not allowed.
• The result is of type float.
•The result can have a null value.
Example
select c1, c3, varp(c1) over (order by c3) from pc2;
C1 C3 VARP(C1)
-- -- --------
1 1 0.25000000000
2 1 0.25000000000
1 0.25000000000
4 2 2.50000000000
5 2 2.50000000000
3 2.50000000000
6 records selected
