FUNCTION: VARP
SELECT VARP(field) AS [expression]
FROM table
[WHERE ...]
[GROUPBY ...]
[HAVING ...]
The VARP function is one of the aggregate functions
that are used to calculate statistical information
for a specified numeric field in a query.
The other aggregate functions are: AVG, COUNT, MAX, MIN, STDEV, STDEVP,
SUM, VAR, .
Note that all of these functions return a single value.
The VARP function finds the variance by using all of
values in a field.
In comaparison, the VAR function only uses a portion,
called a sample, of the values to calculate the variance.
There must be at least two values in the field or the standard
deviation will not be calculated and a NULL value is returned.
This code finds the variance of the age for all MediCare patients
in a hospital and stores that information in VarAge.
SELECT VARP(Age) AS [VarAge]
FROM MediCarePatients
Copyright 2000 by Infinite Software Solutions, Inc.
Trademark Information
|