Difference between revisions of "SUM"
From SQLZOO
| Line 8: | Line 8: | ||
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> | <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr> | ||
</table> | </table> | ||
| − | < | + | <h1>SUM</h1> |
<p>SUM adds a whole column of values.</p> | <p>SUM adds a whole column of values.</p> | ||
<p>SUM is an aggregate function it is normally used with GROUP BY. </p> | <p>SUM is an aggregate function it is normally used with GROUP BY. </p> | ||
| Line 28: | Line 28: | ||
<ul> | <ul> | ||
<li>[http://sqlzoo.net/w/index.php/AVG AVG function]</li> | <li>[http://sqlzoo.net/w/index.php/AVG AVG function]</li> | ||
| − | <li>[ | + | <li>[http://sqlzoo.net/w/index.php/COUNT 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 10:55, 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
