How to SUM two fields within an SQL query
SUM is an aggregate function. It will calculate the total for each group. + is used for calculating two or more columns in a row.
Consider this example,
ID VALUE1 VALUE2===================1 1 21 2 22 3 42 4 5
SELECT ID, SUM(VALUE1), SUM(VALUE2)FROM tableNameGROUP BY IDwill result
ID, SUM(VALUE1), SUM(VALUE2)1 3 42 7 9
SELECT ID, VALUE1 + VALUE2FROM TableNamewill result
ID, VALUE1 + VALUE21 31 42 72 9
SELECT ID, SUM(VALUE1 + VALUE2)FROM tableNameGROUP BY IDwill result
ID, SUM(VALUE1 + VALUE2)1 72 16