-
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
How To Process Large Records in Salesforce Without Hitting the Governor Limits
Batch Classes: - Batch Apex is exposed as an interface that must be implemented by the Salesforce developer. Batch jobs can be programmatically invoked at…
What is Queueable Apex in Salesforce - All You Need to Know
Delivered in Winter '15, Queueable Peak is basically a superset of future strategies with some extra #awesomesauce. We took the effortlessness of future strategies and…
Salesforce Service Cloud Welcomes Einstein AI, Ropes In Quip As Well
A new era of Salesforce Service Cloud is underway with a bunch of Einstein AI capabilities incorporated into the product. The upcoming AI-leveraged Salesforce Service…
Popular Salesforce Videos
Marketing Cloud Connect: Syncing Data Back to Sales and Service Cloud
We demo how to expand the capabilities of Marketing Cloud Connect to automatically sync any data from Marketing Cloud over to Sales and Services Cloud.…
What is Lookup Relationship in Salesforce?
In this video, Shrey is not only teaching but also demonstrating to you "What is Lookup Relationship in Salesforce?". You will be learning: 1. How…
Explore Our Salesforce Story
Explore the origins of Salesforce and how the Futureforce program came to be. Watch this video and do connect with us and share your experience…
