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