Difference between revisions of "SUM"

From SQLZOO
Jump to: navigation, search
(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>...")
 
(2 intermediate revisions by one user not shown)
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>
<h3>SUM</h3>
+
<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 27: Line 27:
 
<p>See also</p>
 
<p>See also</p>
 
<ul>
 
<ul>
   <li>[[AVG function]]</li>
+
   <li>[[AVG |AVG function]]</li>
   <li>[[COUNT function]]</li>
+
   <li>[[COUNT |COUNT function]]</li>
   <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li>
+
   <li>[[MIN |MIN function]]</li>
 
</ul>
 
</ul>

Revision as of 11:39, 13 July 2012

Compatibility
SUM(f)
EngineOKAlternative
ingresYes
oracleYes
postgresYes
sqlserverYes

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

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense