SUM

Returns the sum total of the field in the resultset/group.

 

Example:

With the sample data set:

 

Field1

Field2

Field3

23

10

17

17

10

9

5

12

15

 

 

SELECT SUM(Field1) returns 45.