STDDEV_POP
This function calculates the overall standard deviation and returns the square root of the overall variable with the same return value as the square root of the VAR_POP function.
Example:
select deptno,ename,sal,stddev_pop(sal) over (partition by deptno) as pop from emp; DEPTNO | ENAME | SAL | POP ---------------+------------+------------+------------------- 10 | KING | 10000 | 1546.142152441216 10 | CLARK | 7450 | 1546.142152441216 10 | MILLER | 6300 | 1546.142152441216 20 | SCOTT | 8000 | 1195.339619336511 20 | SMITH | 6800 | 1195.339619336511 20 | JONES | 7975 | 1195.339619336511 20 | FORD | 8000 | 1195.339619336511 20 | ADAMS | 8100 | 1195.339619336511 20 | SMITH | 4800 | 1195.339619336511 30 | ALLEN | 7600 | 2057.506581601462 30 | MARTIN | 6250 | 2057.506581601462 30 | TURNER | 6500 | 2057.506581601462 30 | JAMES | 5950 | 2057.506581601462 30 | BLAKE | 11850 | 2057.506581601462 30 | WARD | 6250 | 2057.506581601462 (15 rows) 
Top comments (0)