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>...")
 
 
(3 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>
 +
 +
{{Languages}}

Latest revision as of 22:41, 22 October 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

Language: English  • Deutsch
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense