SUM

From SQLZOO
Revision as of 08:52, 13 July 2012 by Connor (Talk | contribs) (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>...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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