SUM Example:
| CONTRACT_ID | AMOUNT |
|---|---|
| 1 | 400 |
| 2 | 500 |
| 3 | 700 |
SELECT SUM(c.amount) AS SumAmount
FROM contracts c
WHERE c.amount > 300;
| SumAmount |
|---|
| 1600 |
See also: T-SQL Functions -> Avg -> Count -> Max -> Min
| CONTRACT_ID | AMOUNT |
|---|---|
| 1 | 400 |
| 2 | 500 |
| 3 | 700 |
SELECT SUM(c.amount) AS SumAmount
FROM contracts c
WHERE c.amount > 300;
| SumAmount |
|---|
| 1600 |
See also: T-SQL Functions -> Avg -> Count -> Max -> Min