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 

1.

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

SELECT region, SUM(population) FROM bbc GROUP BY region Submit SQLrestore default

result

See also

• AVG function
• COUNT function
• MIN function

Language:Project:Language policy	English  • Deutsch