-
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
Facebook Salesforce Integration: Why You Should Care and How it Is Suppose to Be
Do you put your best efforts into improving business outreach, customer acquisition, and growth, but outcomes are not always as they should be? Then you…
How to Import multiple images into Salesforce Document folder?
Hello Everyone, Many times we need to import multiple images that are been available into our laptops to the Salesforce org. Yes, I do agree the…
7 Salesforce Challenges Businesses Face During Growth and How Salesforce Experts Solve Them
Business growth brings new opportunities, but it also creates operational complexity. As companies expand into new markets, manage larger sales teams, and handle increasing customer…
Popular Salesforce Videos
Salesforce Service Cloud Einstein Bots
Learn how to set up and use Einstein Bots to increase case deflection and reduce service costs through self-service. This webinar gives you a guided…
Salesforce Admin training : How to create a custom app in Salesforce?
In this tutorial, you will learn to create a custom app in Salesforce and go through a quick overview of Profiles. Profiles control the visibility of your…
Salesforce and Slack | Meet the Slack-First Customer 360
Salesforce and Slack have joined forces to create the Slack-First Customer 360. Now it’s easier than ever to connect customers, employees, and partners with the…
