SQL Server Articles

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

STDEVP Function

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

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

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


Syntax of STDEVP function :

STDEVP (expression )

Expression is avalid expression in sql sever of type numeric except bit data type. 
Return type of STDEVP function is float. 

Example of STDEVP function :


FROM    Products




Above example returns standard deviation for population of royalty column.




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

Sarita Patel
Sarita Patel author of STDEVP 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!