Hi,
I have a request which has to use aggregation, more specifically, 'Having' clause in fetchXml.
The equivalent SQL query is:
Select emailaddress1, count(*) as count
From contact
Where StateCode = 0
Group By emailaddress1
Having count(*)>1
I converted everything fine except the 'Having' clause. Any thoughts?