Difference between revisions of "SUM"
From SQLZOO
| Line 27: | Line 27: | ||
<p>See also</p> | <p>See also</p> | ||
<ul> | <ul> | ||
| − | <li>[ | + | <li>[[AVG |AVG function]]</li> |
| − | <li>[ | + | <li>[[COUNT |COUNT function]]</li> |
| − | <li>[ | + | <li>[[MIN |MIN function]]</li> |
</ul> | </ul> | ||
Revision as of 11:39, 13 July 2012
| SUM(f) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | |
| oracle | Yes | |
| postgres | Yes | |
| sqlserver | Yes | |
SUM
SUM adds a whole column of values.
SUM is an aggregate function it is normally used with GROUP BY.
SELECT region, SUM(population)
FROM bbc
GROUP BY region
With a GROUP BY region statement each region shows up just once. The SUM column gives the total for each region.
SELECT region, SUM(population) FROM bbc GROUP BY region
See also
