|
|
|
STDEVP windowing function
Declaration
STDEVP ( { numeric_expression } ) OVER ( [ partition_by_clause ] order_by_clause )
Description
The analytical window function STDEVP returns the statistical standard deviation for the population for all values within the specified window.
• The argument numeric_expression can be of any numeric type except BIT.
• The result is of type float.
• The result can have a null value.
Example
select c1, c3, stdevp(c1) over (order by c3) from pc2;
C1 C3 STDEVP(C1)
-- -- ----------
1 1 0.50000000000
2 1 0.50000000000
1 0.50000000000
4 2 1.58113900000
5 2 1.58113900000
3 1.58113900000
6 records selected
