Logo 
Search:

SQL Server Articles

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

VARP Function

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

This article explains use of VARP functions available in sql server with different examples.

VARP function is used to perform statistical variance 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 variance for population of an expression.

 

 

Syntax of VARP function :

VARP (expression )

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

Return type of VARP function is float.

 


Example of VARP function :

SELECT VARP(Royalty)

FROM    Products

 

Output

361.838271213972


Above example returns statistical variance for population of royalty column.

  
Share: 

 
 
 

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

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