Returns the sum of the column specified in the expression. SUM can be used with numeric columns only.
Syntax:
SUM ( expression )
Example:
SELECT Size, SUM(Price), SUM(Cost)FROM Merchandise.ProductWHERE Size IS NOT NULLAND Price != 0.00AND Name LIKE 'Tshirt%'GROUP BY SizeORDER BY Size |