Aggregate SOQL Queries
SOQL statements that summarize or group records are called aggregate queries. Aggregate queries in SOQL run at the database level rather than in Apex. This results in much better performance and simpler code. This section covers three aspects of aggregate SOQL queries:
Aggregate functions—Rather than simply returning the discrete values of a database field in a SELECT
statement, aggregate functions such as SUM
apply a simple calculation on each record and return the accumulated result.
Grouping records—The GROUP BY
syntax ...
Get Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.