SOQL GROUP BY サンプル

TerraSkyTechBlog20130417_003

AggregateResult[] results = [SELECT StageName, SUM(Amount) summary 
                               FROM Opportunity 
                              WHERE IsClosed = false 
                              GROUP BY StageName];
for(AggregateResult ar: results){
  System.debug('フェーズ='+ ar.get('StageName') 
               + '：金額='+ ar.get('summary'));
}