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

COUNT()

Return the number of times a field is not NULL in aggregated rows.

Prototype

integer COUNT(expression field = NULL)

Parameters

• field - Optional dot-notation field to count.  The field may resolve to a data-type or content-type (embedded, forward- or back-reference).

Return

Number of times a field is not NULL in aggregated rows.

Example

SELECT OID, Date, COUNT(LineItems) AS NumLineItems FROM Invoice

Related

SUM()

• < AVG()
• GROUP_CONCAT() >