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.