STDDEV returns standard deviation of x, a number. Oracle calculates the standard deviation as the square root of the variance defined for the VARIANCE group function.Syntax: STDDEV([DISTINCT|ALL] x)
SQL Example:SELECT STDDEV(sal) "Deviation"
FROM emp Deviation
----------
1182.50322
SQL Example:SELECT STDDEV(sal) "Deviation"
FROM emp Deviation
----------
1182.50322
----------
16
5
3
2
1
2
1
1
SQL> select sum(num) from forums; SUM(NUM)
----------
31
SQL> select STDDEV(num) from forums;STDDEV(NUM)
-----------
5.083235752