Skip to main content

GROUP BY

Group of records instead of processing many individual records.

SELECT LeadSource
FROM Lead
GROUP BY LeadSource
public inherited sharing class SOQL_Lead extends SOQL implements SOQL.Selector {
public static SOQL_Lead query() {
return new SOQL_Lead();
}

private SOQL_Lead() {
super(Lead.SObjectType);
}
}

public with sharing class MyController {

public static List<AggregateResult> getGroupedLeads() {
return SOQL_Lead.query()
.with(Lead.LeadSource)
.groupBy(Lead.LeadSource)
.toAggregated();
}
}