• ⌂ Aggregate
• Functions
  • AVG()
  • COUNT()
  • GROUP_CONCAT()
  • MAX()
  • MIN()
  • SUM()

SUM()

Return the sum of all non-NULL numeric values in aggregated rows.

Prototype

mixed SUM(expression expression)

Parameters

• expression - Expression or comma-separated list of dot-notation fields to sum.

Return

Sum of expression evaluated for each aggregated row that evaluate to a numeric value.

Example

SELECT OID, Date, SUM(Items.Quantity * Items.Amount) AS Total FROM Invoice

Related

COUNT()

• < MIN()
• Date & Time >