Contents
What is AggregateResult in salesforce?
AggregateResult is a read-only sObject and is only used for query results. The values in the AggregateResult object can be accessed much like a map calling a “get” method with the name of the column. The AggregateResult query is used to capture the result of the query and to get the value using an alias name.
What do you know about Aggregate SOQL query’s and what they meant?
Aggregate functions in SOQL, such as SUM() and MAX() , allow you to roll up and summarize your data in a query. You can use aggregate functions without using a GROUP BY clause. For example, you could use the AVG() aggregate function to find the average Amount for all your opportunities.
How to extract the value from an aggregateresult?
Note that any query that includes an aggregate function returns its results in an array of AggregateResult objects. AggregateResult is a read-only sObject and is only used for query results. You need to extract the value from the first element of the result:
How to use aggregateresult in soql in apex?
The aggregate functions COUNT (fieldname), COUNT_DISTINCT (), SUM (), AVG (), MIN () and MAX () in SOQL return an AggregateResult object or a List of AggregateResult objects. We can use aggregate functions result in apex by using AggregateResult object. Here is an example to use AggregateResult in Salesforce.
When to use aggregateresult as a read only sobject?
AggregateResult is a read-only sObject and is only used for query results. You need to extract the value from the first element of the result: Thanks for your reply!
Which is an example of aggregateresult in Salesforce?
Here is an example to use AggregateResult in Salesforce. In below example I’m using COUNT (fieldname) aggregate function in SOQL to show Account record respective number of Contacts. We were unable to load Disqus Recommendations.