|
|
|
STDEV windowing function
Declaration
STDEV ( { numeric_expression } ) OVER ( [ partition_by_clause ] order_by_clause )
Description
The analytical window function STDEV returns the statistical standard deviation of 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, stdev(c1) over (order by c3) from pc2;
C1 C3 STDEV(C1)
-- -- ---------
1 1 0.70710680000
2 1 0.70710680000
1 0.70710680000
4 2 1.82574200000
5 2 1.82574200000
3 1.82574200000
6 records selected
