Aggregate Functions are functions that operate on a set of rows to calculate and return a single value.
It is often necessary to summarize data without actually retrieving it all, and SQL provides special functions for this purpose.
Examples of this type of retrieval are:
Determining the number of rows in a table.
Obtaining the sum of a set of rows in a table.
Finding the highest, lowest, and average values in a table column.
Following is the list of frequently using Aggregate Functions:
|AVG()||Returns a column's average value|
|COUNT()||Returns the number of rows in a column|
|MIN()||Returns a column's highest value|
|MAX()||Returns a column's lowest value|
|SUM()||Returns the sum of a column's values|
If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!