-
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
What is Salesforce Marketing Automation in 2024?
Without a question, automation is growing more and more prevalent in today's majority of businesses. Automated machinery is seen at hotels, restaurants, and manufacturing facilities,…
Hello World Code for Salesforce Einstein
As a programmer, We do code in many languages. We create always a program named as Hello World. This blog is all about for Hello…
Salesforce Lookup Relationship and Salesforce Master-Detail Relationship: An Overview
The relationship is used to connect different Objects within org. Salesforce provides the following types of relationships : Lookup relationship Master-Detail relationship Self-relationship External lookup…
Popular Salesforce Videos
How To Use Journey Builder In Salesforce Marketing Cloud | Salesforce Tutorial
How to use Journey Builder in Marketing Cloud. This video will cover the following points - 1. Introduction Get a brief introduction to Journey Builder…
Salesforce Staff Has Option to Keep Working From Home
Dan Bognar, head of the strategy for Asia at Salesforce.com Inc., discusses how the coronavirus outbreak is affecting the San Francisco-based software maker’s operations and…
How to Get Started with Data Prep | Salesforce
Good data preparation allows for efficient analysis, limits errors and inaccuracies that can occur to data during processing, and makes all processed data more accessible…
