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 Release Notes (version 3.10.0) – mass edit custom fields on lightning
- Salesforce DevTools Release Notes (version 3.9.0) – Object Fields, SOQL Query Editor
- Salesforce DevTools Release Notes (version 3.8.0)
- Salesforce DevTools JUST HIT 10,000 USERS! THANK YOU!
- Using Promise for Apex Server-Side request in Lightning Component
Top Posts
- Salesforce DevTools – Powerful Salesforce developer tools, loved by over 50K developers - 186.6K views
- Date format and DateTime format - 163.2K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 126.6K views
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 117K views
- Writing a Schedulable Batch Apex in Salesforce - 90.6K 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 DevTools
- Salesforce DX
- SOQL
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress
You must be logged in to post a comment.