SQL Server Articles

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

VARP Function

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

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 :


FROM    Products




Above example returns statistical variance for population of royalty column.



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!