-
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
Salesforce and Gmail Integration | The Perfect Integration Guide
Salesforce Gmail Integration Gmail is a free Web-based Mail service that provides users with gigabytes of storage for emails and information and provides the ability…
14 Key Points to Keep in Mind Before Migrating Your Online Community
Your online community might be huge—built on Jive, Lithium, Drupal, or Salesforce—or based on a basic software system, such as Ning. Irrespective of the size,…
How to Share Salesforce Visualforce Pages Between Classic and Lightning Experience?
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…
Popular Salesforce Videos
How To Become A Salesforce Administrator | Salesforce Administrator Training
What does Salesforce developer do? Salesforce developers lead the testing and implementation of software development efforts, including coding, configuration, maintenance, installation, testing, and debugging, as…
Introduction to Set & Map in Salesforce || What is Set || What is Map ||
From Salesforce instructor, Become a Salesforce Expert. A brief introduction about what is a Set, map, and what are their importance? Check out the video to…
Salesforce Sandbox Tutorial | Salesforce Training Videos For Beginners
The Salesforce Sandbox is a copy of a production Salesforce environment used for a variety of purposes, commonly including testing and development. Here's how Salesforce…