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.