-
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 Workbench - The Complete Developer Guide
What is Salesforce Workbench? Salesforce Workbench is a tool that brings together a number of advanced features and capabilities into one place. A lot of…
Send OTP Using Login Flow | Salesforce Developer Guide
Two-factor authentication is the best path to employ for high standards security. This method includes adding a second factor to the login and password, with…
Steps to Send a Marketing Cloud Email by using Triggered Sends in Sales Cloud
Steps to send a Marketing cloud Email by using Triggered send in sales cloud Note - First you have to enable the Triggered send in…
Popular Salesforce Videos
Simple Salesforce to Salesforce Data Migration Step by Step | 100% Salesforce Native App
How to Migrate Salesforce Data? Create Template: As the name suggests, this is just like a sandbox template; these templates store template lines & various…
Salesforce Customer 360 Audiences Enhancements
Salesforce Customer 360 is a tool that allows companies to connect Salesforce apps and create a unified customer ID to build a single view of…
COVID-19 Impact on The Automotive Industry -Digitization With Salesforce Can be a Solution
Coronavirus is expected to create a physical contactless environment with an increased thrust on online assessment and buying of vehicles. This is a huge shift…
