-
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
A Beginners Guide to Salesforce Trailhead and Certification Paths
Salesforce is one of the most widely used customer relationship management (CRM) platforms in the world. Its popularity has led to a growing demand for…
10 Must-Know Tips for Aspiring Salesforce Admins
Salesforce is a powerful customer relationship management (CRM) platform used by businesses worldwide to streamline their sales, marketing, and customer support operations. Behind the scenes…
What is the Future of Salesforce After COVID-19?
As more and more people get their COVID-19 jabs, Salesforce is gearing towards the future of office work with technology facilitating hybrid work and the…
Popular Salesforce Videos
Salesforce CPQ Subscription Pricing
Configure Price Quote (CPQ) is a powerful sales tool that enables companies to produce accurate and highly configured sales quotes for customers — especially in…
Use cases Automation UiPath with Salesforce
The following video demonstrates a UiPath Robot automatically populating Salesforce using data read from an Excel spreadsheet....imagine how UiPath Robots could accelerate your Salesforce activities.…
How Salesforce AppExchange Can Boost Your Application's Marketing ?
Explore the key benefits of AppExchange, the largest business app marketplace, and discover how you can tap into its vast ecosystem of potential customers. In…
