Achieve your business goals faster by unlocking our Salesforce Cloud Services.
“SOQL Aggregate Functions” shows a calculated result from the query and returns AggregateResult.
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.
AggregateResult ar = [SELECT SUM(Max_Salary__c)
FROM Position__c WHERE Max_Salary__c > 10000];
AggregateResult ar = [SELECT MAX(Max_Salary__c)
FROM Position__c
WHERE Max_Salary__c > 10000];
AggregateResult ar = [SELECT MIN(Max_Salary__c)
WHERE Max_Salary__c];
Integer i = [SELECT count(ID) FROM Account];
AggregateResult ar = [SELECT AVG(Min_Salary__c)
WHERE Max_Salary__c < 5000];
AggregateResult ar = [SELECT COUNT_DISTINCT(Name)
FROM Position__c];
< < Previous
Next > >
The batch is going to start shortly. Fill the form given below to Register yourself now.
Fill the form below to get a Result
Fill the form below to get a demo of this course.
Online Salesforce Development Course is soon going to be launched. Please fill the form and we will notify you about the course.