-
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
Lead Conversion In Salesforce | Best Practices
Focussing on lead conversion, it can be understood as a process of converting a lead to account, contact, and/or opportunity. Lead generation in Salesforce can…
Matching And Duplicate Rules | All You Need to Know
Matching And Duplicate Rules Matching and Duplicate Rules are features used in software applications, such as customer relationship management (CRM) systems, to identify and manage…
Salesforce Marketing Cloud Personalization Overview
Suppose you've attracted leads to your website or app. Some of them converted into prospects. You carry on gathering data, but they keep unsubscribing or…
Popular Salesforce Videos
Create Survey in Salesforce | #Feedback Program #Salesforce Tutorials | Mini Project
In this video you will learn : What are the surveys? Why businesses use surveys? And how you can create and send surveys using #Salesforce? …
Salesforce Admin Certification 2020 Questions Explained with References - Part II
How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam Questions Salesforce Administrator Certification Exam…
How to Become Salesforce Developer | Salesforce For Beginners
In this how-to become Salesforce developer video, you will be learning what is Salesforce, the fundamentals of Salesforce, how to become a Salesforce developer, how…
