-
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
Salesforce Integrations - Enterprise Portfolio Considerations
Why Salesforce Integration? What are the Benefits? We live in a world where even the smallest of organizations have multiple systems in their IT Footprint…
Syna World Windbreaker: Where Streetwear Style Meets Everyday Performance
In modern fashion, outerwear has evolved beyond basic protection. Today, jackets and windbreakers represent personality, confidence, and lifestyle. The Syna World Windbreaker is a perfect…
How an HMS Simplifies Hospital Inventory and Supply Chain Management
Introduction A hospital management system (HMS) plays a crucial role in streamlining hospital operations by automating processes, reducing manual tasks, and improving efficiency. From clinic management and…
Popular Salesforce Videos
Salesforce Resume Review
Salesforce is a well-known company and leader in the cloud computing space so we would say it would be an asset on a resume. Thinking…
Solving the Fizz Buzz (SSJS) in Salesforce Marketing Cloud
Cameron Robert from Datarati uses 2 different approaches to solve the Fizz Buzz programming challenge using SSJS Salesforce Marketing Cloud. What you'll learn: » How…
How To Use Javascript Editor In Formstack Part 2 - Learn Salesforce Series By Algoworks
Learn how to integrate Javascript editor in Formstack in this Salesforce tutorial brought to you by Algoworks. Did you miss the complete tutorial? To watch…
