Previous Topic Next topic Print topic


Specifying Aggregate Functions for Columns

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
Previous Topic Next topic Print topic