SQL Server Articles

Submit Article
Home » Articles » SQL Server » Aggregate FunctionsRSS Feeds

STDEV Function

Posted By: Sarita Patel     Category: SQL Server     Views: 9085

This article explains the use of STDEV function in sql server with example.

STDEV function is used to perform statistical standard deviation of all values in the given expression.It can be used with numeric type columns only. Null values are ignored while performing deviation of an expression.


Syntax of STDEV function :

STDEV (expression )

Expression is avalid expression in sql sever of type numeric except bit data type.

Return type of STDEV function is float.


Example of STDEV function :


FROM    Products





Above example returns standard deviation of royalty column.



Didn't find what you were looking for? Find more on STDEV Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of STDEV Function is from United States.
View All Articles

Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

No Comment Found, Be the First to post comment!