Previous Topic Next topic Print topic

Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > OpenESQL > Programming for OpenESQL > OpenESQL Assistant > Using OpenESQL Assistant > Building Queries > Specifying Aggregate Functions for Columns

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
Parent topic: Building Queries
Related tasks
To perform an aggregate function
Previous Topic Next topic Print topic