You can specify an aggregate function for any column in a SELECT (cursor) or SELECT DISTINCT (cursor) query. An aggregate function retrieves certain information about the data returned from a column.
OpenESQL returns the following information for each group of returned data:
| Aggregate Function | Value for each group of returned data |
|---|---|
| Sum | Sum of all values returned (numerical columns only) |
| Avg | Average of all values returned (numerical columns only) |
| Max | Maximum value returned |
| Min | Minimum value returned |
| Count | Number of records returned |