-
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 to use Loading Spinner in Salesforce Lightning Component?
How to use Loading Spinner in the Salesforce Lightning Component? Definition of Loading Spinner: Don’t forget to check out: How Variable Types Operate in the…
Guide for Small Business: Unlocking Growth with Salesforce Pro Suite
In the evolving digital landscape, Salesforce for small businesses is not just a CRM platform; it's a growth accelerator, reshaping how SMEs connect with customers…
How to Become a Salesforce Developer in 2024?
The world of customer relationship management (CRM) is undergoing a revolution, and at the forefront stands Salesforce, the undisputed king of cloud-based CRM solutions. But…
Popular Salesforce Videos
Attribute Setup for Skill based Routing in Salesforce
This video is 3rd Part of the Omnichannel Series. Implementation of Attribute set up skill-based routing with the demo. Do let us know in the…
Building a Business Case for an Investment in Salesforce - Education Cloud
Education Cloud is a leading platform that empowers your institution to become a Connected Campus, so you can transform the student journey. With the power…
Salesforce and Disney Studios Join Forces
Salesforce and Disney Studios Content recently announced a five-year innovation partnership to help support Disney filmmakers and marketers using the Salesforce platform. By naming Salesforce…
