SQL SUM Function

This example returns the sum of all orders.

SELECT SUM(TotalAmount) AS Total
  FROM [Order]

Syntax of the SUM function.

SUM(value)

SELECT MONTH(OrderDate) AS Month
       SUM(TotalAmount) AS 'Total Sales'
  FROM [Order]
 WHERE YEAR(OrderDate) = 2013
 GROUP BY MONTH(OrderDate)

Month	Total Sales
1	66692.80
2	41207.20
3	39979.90
4	55699.39
5	56823.70

SELECT SUM(UnitPrice * Quantity) AS 'Total Sales'
  FROM [Order] O
  JOIN OrderItem I ON O.Id = I.OrderId
 WHERE I.ProductId = 14 AND YEAR(OrderDate) = 2014

• Our Sql Aggregate Functions Reference
• Our Sql AVG Function Reference
• Our Sql COUNT Function Reference