Apex Intermediate Progress | ( Lessons)

Lesson: 133 | AggregateResult[]

Notes
Video

Notes

In Salesforce Apex, AggregateResult[] is an array type used to store the results of aggregate queries. Aggregate queries allow you to perform calculations on your data, such as counting, summing, averaging, or finding the minimum or maximum values. The AggregateResult type is specifically designed to work with the results of such queries.

Here's a brief explanation and example of how AggregateResult[] is typically used:

List<AggregateResult> aggregateResults = [SELECT StageName, COUNT(Id) recordCount, AVG(Amount) avgAmount
                                          FROM Opportunity
                                          GROUP BY StageName];

for (AggregateResult result : aggregateResults) {

    Integer count = (Integer)result.get('recordCount');
    Decimal avgAmount = (Decimal)result.get('avgAmount');

    System.debug('Stage: ' + result.get('StageName') + ', Records: ' + count + ', Average Amount: ' + avgAmount);
}

Output: Stage: Prospecting, Records: 2, Average Amount: 354920.75

Prev You need to login to have access to the quizzes. Next

Mastered by 21 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

J. Miscellaneous (17 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 133 | AggregateResult[]

Notes

Apex Intermediate