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)