What is STDEV Function in SQL?

Programming Language
#1

The SQL STDEV Function is an Aggregate Function, which is is used to calculate the Standard Deviation of total records (or rows) selected by the SELECT Statement.

The STDEV Function works only on Numeric Columns, and ignore Nulls. This function is used to calculate population standard deviation of an expression.

Syntax :

STDDEV_POP(expr);

Parameter : This method accepts only one parameter.

  • expr – Input expression from which we want to calculate population standard deviation.

Returns : It returns the population standard deviation.