Group by multiple fields in SOQL
- May
- 11
- Posted by Lin
- Posted in Salesforce, SOQL
In this post I’ll show you the useage of Group By in SOQL.
*Amazingly,SOQL supports groupping with multiple fields.
*Amazingly,SOQL supports groupping with multiple fields.
The data
I have prepared the data by Saels__c sObject, whose Account__c field is reference to Account,User__c field is reference to User, and Amount__c field is a Currency field.
Group By
1.Simple Group BY

1.Group by two fields

1.Use GROUP BY ROLLUP
Use the ROLLUP in SOQL query will add subtotals for aggregated data in query results.
Recent Posts
- Salesforce DevTools JUST HIT 10,000 USERS! THANK YOU!
- Using Promise for Apex Server-Side request in Lightning Component
- Pipeline for Salesforce – Be less busy, less mistake in Salesforce metadata deploy
- Salesforce Smart Importer – 1-Drag to import Excel / CSV in Salesforce, supports both Classic and Lightning!
- Setup Salesforce DX IDE environment with Visual Studio Code
Top Posts
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 101.8K views
- Salesforce DevTools – Powerful Chrome extension for Saleforce.com developer - 97.7K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 63.1K views
- Date format and DateTime format - 55.2K views
- Writing a Schedulable Batch Apex in Salesforce - 49.7K views
Categories
- APEX
- Apps
- Custom Label
- Custom Metadata
- Custom Setting
- Design & UI
- Event
- Heroku
- iOS & Object-c
- Lightnint Component
- Linux & Mac OS
- Metadata API
- Node.js
- Open Source
- Other
- PHP Framework
- Release Notes
- REST API
- Salesforce
- Salesforce DX
- SOQL
- Tesforce
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress