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

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

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“.