-
Can you use Group by clause inside inner query in Salesforce SOQL?
Can you use aggregate expressions inside inner query?
Explanation – Can you use Group by clause inside inner query in SOQL?
Example : Something like :SELECT Id, Name,(SELECT Count(Id),Name FROM Contacts Group By Name Having count(Id) > 1 ) FROM Account
-
3 Replies
-
No. only root queries support aggregate expressions. Return type is List<AggregateResult> for above query However the root result expects List<Account> and there is no syntax or provision available in Salesforce to specify that child results are of type “AggregateResult“.
-
SELECT Id, Name,(SELECT Count(Id),Name FROM Contacts Group By Name Having count(Id) > 1 ) FROM Account
No only root queries support aggregate expression.
-
No we cannot use aggregate expression.
Thanks.
Log In to reply.
Popular Salesforce Blogs
How Salesforce Einstein Works for FinTech: Features & Benefits Overview
67% of respondents consider artificial intelligence to be a top technology that will influence fintech over the decade. At the forefront of fintech's dynamic progress, Salesforce…
What is SOQL in Salesforce in 2023? | The Developer Guide
In this Blog we will learn about SOQL in salesforce. What is SOQL? SOQL stands for Salesforce Object Query Language. When we have to perform…
How to manage Leads in Salesforce Sales Cloud? | Salesforce Sales Cloud
Salesforce Sales Cloud is a cloud-based application designed for different-sized enterprises to manage sales efficiently by collecting customer data and inputs of their interaction with…
Popular Salesforce Videos
Lead Together with Salesforce | Salesforce Partners
Learn more about the Equality Programs and initiatives that are available to Salesforce Partners, including the Salesforce Talent Alliance. Watch this video to learn all…
What is Validation Rule in Salesforce? Explain in details
Validation Rule will check the data entered by user during insert or update the operation and as per that it will actually take the action.…
Auditing Account Deletion Using Salesforce Flow
This demo video walks through an example of Auditing Account Deletion Using Salesforce Flow Ever had an instance where users have accidentally deleted Accounts and…
