Stddev – Oracle SQL Function

STDDEV returns the sample standard deviation of the expression.

STDDEV will return zero when it has only one row of input data.

Syntax:

STDDEV(expression)

Example:

SELECT STDDEV(COMMISSION_PCT) FROM EMP;

STDDEV(COMMISSION_PCT)
——————————————–
.0857432345