Difference between revisions of "SUM"
From SQLZOO
(Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>SUM(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td>...") |
|||
| Line 27: | Line 27: | ||
<p>See also</p> | <p>See also</p> | ||
<ul> | <ul> | ||
| − | <li>[ | + | <li>[http://sqlzoo.net/w/index.php/AVG AVG function]</li> |
<li>[[COUNT function]]</li> | <li>[[COUNT function]]</li> | ||
<li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li> | <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li> | ||
</ul> | </ul> | ||
Revision as of 08:59, 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
