SOQL Aggregate Functions
“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.
1. Sum():
AggregateResult ar = [SELECT SUM(Max_Salary__c)
FROM Position__c WHERE Max_Salary__c > 10000
];
2. Max():
Max(): AggregateResult ar = [SELECT MAX(Max_Salary__c)
FROM Position__c
WHERE Max_Salary__c > 10000
];
3. Min():
Min(): AggregateResult ar = [SELECT MIN(Max_Salary__c)
FROM Position__c
WHERE Max_Salary__c
];
4. Count() and Count(fieldName):
Integer i = [SELECT count(ID) FROM Account];
5. Avg():
Avg(): AggregateResult ar = [SELECT AVG(Min_Salary__c)
FROM Position__c
WHERE Max_Salary__c < 5000
];
6. Count_Distinct():
Count_Distinct(): AggregateResult ar = [SELECT COUNT_DISTINCT(Name)
FROM Position__c
];