SUM

Compatibility

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

• AVG function
• COUNT function
• MIN function

Language:Project:Language policy	English  • Deutsch