Skip to main content

Aggregate Functions

Zuora

Aggregate Functions

Overview

As of release 34.0, Export ZOQL supports several aggregate functions, detailed below.

Note that Export ZOQL is used for creating exports from Zuora data sources, and uses a different syntax than standard ZOQL.

avg()

Use avg() to return the average value. 

Limitations

The avg() function supports only numeric values. 

Example

select A.a,avg(A.c) from A group by A.a, B.b

count()

Use count() to return the number of rows. Similar to standard SQL, you can use the following syntax with count():

  • count(*)
  • count(field)

​The count() command is the only Export ZOQL command that supports the use of an asterisk (*). 

Example

select count(*) from A

max()

Use max() to return the largest value.

Example

select count(a),max(c),b from A group by b

min()

Use min() to return the smallest value.

Example

select count(a),min(c),b from A group by b

sum()

Use sum() to return the sum.

Limitations

The sum() function supports only numeric values. 

Example

select A.a, sum(A.b) from A

Limitations of the Aggregate Functions

The aggregate functions have the same limitations as standard SQL aggregate functions.

In addition to specific limitations, you cannot nest aggregate functions.