Quick References
ADO
ASP
CSS2
HTML
JavaScript
Jet SQL
VBScript
WML
WMLScript
WSH
XHTML
XML DOM
XSLT
Features
Knowledge Base
Tutorials
Partners
ZVON.ORG
XML
Planet Source Code
VisualBuilder
Web Design
Your HTML Source
XML/XSLT Forums
ASPAlliance
Scripts
Programmers Heaven
Tek-Tips Forums
Developer Fusion
Code Project
All Functions
WHERE Clause
HAVING Clause
GROUP BY Clause
FUNCTION: VAR
SELECT VAR(field) AS [expression]
FROM table
[WHERE ...]
[GROUPBY ...]
[HAVING ...]
The
VAR
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, VARP
. Note that all of these functions return a single value.
The
VAR
function finds the variance by using a portion, called a sample, of the total number of values in a field. This is a time saver when dealing with extremely large tables and can be shown to be statistically valid. In comparison, the
VARP
function uses all of the values to calculate the variance. There must be at least two values in the field or the variance will not be calculated and a
NULL
is returned.
This code finds the variance of the age of the MediCare patients in a hospital (by using a sample) and stores that information in VarAge.
SELECT VAR(Age) AS [VarAge]
FROM MediCarePatients
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
