Tag Archives: Aggregate function

Aggregate Functions in Salesforce Visualforce page

Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. Aggregate functions include AVG(), COUNT(), MIN(), MAX(), SUM(), and more. You can also use aggregate functions without using a GROUP BY clause. For example, you could use the AVG() aggregate function to find the average Amount for all your opportunities. Example SELECT AVG(Amount)FROM Opportunity GROUP BY clause is used in SOQL query to… Read More »