Logo 
Search:

SQL Server Articles

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

STDEVP Function

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

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 :

SELECT STDEVP(Royalty)

FROM    Products

 

Output

19.0176329973953


Above example returns standard deviation for population of royalty column.

 

  
Share: 

 
 
 

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!