SOQL HAVINGサンプル

TerraSkyTechBlog20130417_004

AggregateResult[] results = [SELECT LeadSource, SUM(Amount) summary 
                               FROM Opportunity 
                               GROUP BY LeadSource 
                               HAVING Count(LeadSource) > 20];
for(AggregateResult ar: results){
  System.debug('リードソース='+ ar.get('LeadSource') 
                   + '：金額='+ ar.get('summary'));
}