To perform an aggregate function

  1. In the OpenESQL Assistant, create a SELECT (cursor) or a SELECT DISTINCT (cursor) query.
  2. On the tree view, right-click a column name.
  3. Click an aggregate function to perform on the column.
Note: For more information about aggregate functions, see the SQL documentation for your DBMS.