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