In a standard query, each row in the result set corresponds to an individual row in the table that you are querying. Sometimes, however, you instead want a summary of the information in multiple rows.

 

An aggregate function is a special type of operator that returns a single value based on multiple rows of data. When your query includes one or more aggregate functions, PeopleSoft Query collects related rows and displays a single row that summarizes their contents.

 

For instance, instead of viewing multiple rows of data, you may want to view only a count of rows or the sum of a numeric field. You can use the aggregate function to produce these results by grouping data and performing calculations on a field that is within the group.

 

In Query Manager, you use aggregate functions to:

• Associate query fields with predefined calculations.

• Return a single value for multiple rows of output.

 

In this topic, you will review aggregate functions.


Table of Contents