-
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
Auditing Salesforce Org - Salesforce Security Guide
As we all know, security is the first priority in Salesforce. Salesforce provides different types of security features so customers' data is safe. In this…
Why is Salesforce an Indisputable CRM Platform?
Salesforce is a customer relationship management (CRM) solution that helps businesses with growing data generation. It aligns companies with their customers via tools of marketing,…
SALES PATH: Your Company’s Sales Processes in Lightning Experience
Sales Path is a great feature that Salesforce is made available for Lightning Experience only. This tool is designed to guide your sales reps through…
Popular Salesforce Videos
Salesforce and Slack: Success from Anywhere - Your Digital HQ
Welcome to Success from Anywhere: Your Digital HQ. Join our Slack-First Customer 360 event to find out more. Register now: https://www.salesforce.com/events-master/digital-hq/ Success Anywhere means coming…
Salesforce Marketing Cloud: Journey Builder Demo
With Journey Builder from Marketing Cloud, send your customers personalized, connected experiences to build lasting relationships with your brand. Watch this video and learn.
Driving Sales Productivity and Motivations from Your Salesforce Data
Meet OneUp Sales, the revolutionary sales motivation platform built for modern sales teams. By leveraging data extracted from systems you already use, OneUp powers lively…
