-
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“.
- [adinserter block='9']
-
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
Going Beyond Traditional Implementation Methodologies for Salesforce Service Cloud: A Fireside Chat
Salesforce Service Cloud has myriads of capabilities that enable you to ace your customer service game. But optimizing Service Cloud the right way calls for…
Enhancing Non-Profit Operations with Salesforce Customer Portal
In today's digital age, non-profit organizations strive to leverage technology to streamline their operations and enhance constituent engagement. One powerful tool that empowers non-profits is…
Salesforce PDO Partner Program 2021: A Guide
Salesforce AppExchange has been a huge hit across its 15-year lifespan and is the key differentiator for Salesforce when it comes to the global CRM…
Popular Salesforce Videos
Rise & Shine with The Salesforce Women's Entrepreneur Group
The Salesforce Women’s Entrepreneur Group invites you to our first quarterly event of the year, Rise & Shine - Celebrating Women’s History Month. We are…
Control Access to the Org | Data Security | Salesforce
In this video, wonder Studies explains how to control access to your Salesforce org and the data security measures you can take to protect your…
Learn About How to Set Profiles in Salesforce?
Learn about Profiles in Salesforce and types of profiles, Standard and Custom Profiles. Watch this video and do let us know in the comment section…
