FUNCTION: SUM
SELECT SUM(field) AS [expression]
FROM table
[WHERE ...]
[GROUPBY ...]
[HAVING ...]
The SUM 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,
VAR, VARP.
Note that all of these functions return a single value.
The SUM function simply adds all of the values in a field
and return the total sum.
This code finds the total number of days that MediCare patients stayed
in the hospital and stores that information in MCTotalDays.
SELECT SUM(DaysInHospital) AS [MCTotalDays]
FROM MediCarePatients
WHERE age > 65
Copyright 2000 by Infinite Software Solutions, Inc.
Trademark Information
|