Using the Relational Data Framework › Use Expressions and Functions › Numeric Aggregate Functions › List of Aggregate Functions

List of Aggregate Functions

Keep this information in mind when using aggregate functions:

• You can use more than one aggregate function in a SELECT statement, but you must specify each function separately.
• To obtain the values of aggregate functions, your SELECT statement must include values for the INTO keyword. For example, consider the following:

  SELECT AVG (COST) COUNT (*) INTO :variable1 :variable2 FROM WORKSTATIONS
  

There are five aggregate functions provided with CA OPS/MVS:

• AVG-Returns the average value in a specified column
• COUNT-Returns the number of rows in a specified table
• MAX-Returns the maximum value in a specified column
• MIN-Returns the minimum value in a specified column
• SUM- Returns the sum of all values in a specified column