-
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
Learn All About How to Use Lightning Spinner | Salesforce Lightning Component
Lightning spinner shows an animated spinner icon that specifies your request is loading or in simple words, we can say that it is a loading…
How To Use jQuery DataTable Plugin In Salesforce Lightning Component?
DataTables: "DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, build upon the foundations of progressive enhancement, that adds…
Use of Database.Statefull in Batch Apex when aggregating values for large data
We often came across situations in apex where we are required to calculate aggregate data but we have a limitation of 50000 records at a…
Popular Salesforce Videos
Salesforce Lightning Training - Creating Hello World Lightning Component
Data Loader is a utility to perform bulk database operation. Recently Salesforce has changed the way data loaders need to be install. I explain end…
TOP 20 Salesforce Integration Interview Questions and Answers 2019 | Salesforce Integration
In this video, Wisdom Jobs and Tutorials explains the 20 most popular questions asked during Salesforce Integration interviews. These questions cover topics like what web…
Share Visualforce Pages Between Classic and Lightning Experience | Salesforce Trailhead
Visualforce Pages should be created correctly such that they behave properly whether they run in Salesforce Classic or Lightning Experience. Detecting and Responding to the…
