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

AVG()

Return the average of the results of an expression performed on all aggregated rows where the result is a number.

Prototype

mixed AVG(expression expression)

Parameters

• expression - An expression, such as a dot-notation field that will be evaluated and the result averaged for each aggregated row.

Return

Average of the results of an expression performed on all aggregated rows where the result is a number.

Example

SELECT OID, Date, AVG(LineItems.Amount) AS Avg FROM Invoice

Related

SUM()

• < Aggregate
• COUNT() >