Aggregate Functions

The XDB Server supports a number of aggregate functions that are used with the SELECT command to operate on the values from a specified column. The column-name that follows the function must be enclosed in parentheses. The result of an aggregate function is a single value for every group in the query result. If the query result is not grouped, the entire result is treated as a single group, and the result of an aggregate function is a single value.

More: