groupby query having count > 1

2267
0
02-21-2016 04:22 PM
DavinShokes1
Occasional Contributor

I want to do a rest query that matches:

SELECT        CustomerID, COUNT(CustomerID) AS IDCounts

FROM            Property

GROUP BY CustomerID

HAVING        (COUNT(CustomerID) > 1)

I don't see where do put having parameters in the REST interface.

Any ideas? Thanks.

0 Kudos
0 Replies