Tuesday, August 1, 2017

AggregateResult In SalesForce



Requirement:  To retrieve number of employees with salary greater than 25000, we would use : 



LIST<AggregateResult> noOfEmployees = new LIST<AggregateResult> (); noOfEmployees = [SELECT COUNT(id) noOfEmp FROM Employee__c WHERE salary__c > 25000 ]; for(AggregateResult sobj : noOfEmployees)
{
 Integer empNumber = Integer.valueOf(sobj.get('noOfEmp'));

}

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.