Basic aggregation functions

FirstSortedValue() returns the value of the first expression that corresponds to the first value in the sort order of the second expression iterated over a number of records, as defined by a group by clause.

firstsorted([ distinct ] expression [, sort-weight [, n ]])

Max() finds the highest numeric value of the aggregated data in the expression, as defined by a group by clause. By specifying a rank n, the nth highest value can be found.

max( expression[, rank])

Min() returns the lowest numeric value of the aggregated data in the expression, as defined by a group by clause. By specifying a rank n, the nth lowest value can be found.

min( expression[, rank])

Mode() returns the most commonly-occurring value, the mode value, of the aggregated data in the expression, as defined by a group by clause. The Mode() function can return numeric values as well as text values.

mode(expression )

Only() returns a value if there is one and only one possible result from the aggregated data. If records contain only one value then that value is returned, otherwise NULL is returned. Use the group by clause to evaluate over multiple records. The Only() function can return numeric and text values.

only(expression )

sum([distinct]expression)

FirstSortedValue() returns the value of one field based on the sorted values of another field. For example, the product with the lowest unit price.

firstsortedvalue([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] value, sort_weight [,rank])

max([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr [,rank])

Min() finds the lowest value of the aggregated data. By specifying a rank n, the nth lowest value can be found.

min([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr [,rank])

Mode() finds the most commonly-occurring value, the mode value, in the aggregated data. The Mode() function can process text values as well as numeric values.

mode({[SetExpression] [TOTAL [<fld {,fld}>]]} expr)

Only() returns a value if there is one and only one possible result from the aggregated data. For example, searching for the only product where the unit price =9 will return NULL if more than one product has a unit price of 9.

only([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr)

Sum() calculates the total of the values given by the expression or field across the aggregated data.

sum([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr])