-
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
Salesforce Automation Process
Introduction - Salesforce provides multiple tools to automate your organization's business processes. These Salesforce Automation are - Don’t forget to check out: Salesforce Automation with Flow…
Apex Batch - Use of Interface Database.Stateful in Batch Class
Hello guys, Today, we will talk about interface named as Database.Stateful, it is used when we want to maintain the state across the batch call…
Top Reasons Why To Go For Salesforce Customization
Establishing a business with CRM implementation is a key tactical business decision. Some companies choose to “turn ON” Salesforce by allocating licenses and passwords, however,…
Popular Salesforce Videos
Strategy Design Pattern in Salesforce | Video Tutorial
Design Patterns are very important for us to understand to develop an efficient apex code. Watch this video to learn all about it and do…
Slack API Integration for Salesforce Marketing Cloud
Connect Salesforce Marketing Cloud and Slack the way you want. Watch this video to learn all about Slack API Integration for Salesforce Marketing Cloud. If…
Career in Salesforce in 2022
In this video, Shrey is talking about starting your career in Salesforce. Here are the different career choices you have or different profiles that are…
