When you apply an aggregate function to a field, you are redefining how Oracle PeopleSoft Query uses the field throughout the query.

 

When you apply an aggregate function to a field, PeopleSoft Query replaces the field, wherever it occurs, with the results of the function. If you select the field as a display column, PeopleSoft Query displays the aggregate values; if you use the field as an order-by column, PeopleSoft Query orders the results based on the aggregate values.

 

If you do not want PeopleSoft Query to redefine the field in this way—for example, if you want to display both the individual row values and the results of the aggregate function—create an expression that includes the aggregate function rather than applying the function directly to the field.

 

In this topic, you will review how to apply an aggregate function to a field.


Table of Contents