Find count greater than 1 in Azure CosmosDB

98 Views Asked by At

I am querying the below to get the count, uniqueid, Amount Select uniqueID,c.AmtPercent, count(1) as count from c Group by c.uniqueId, c.AmtPercent

I want the rows where count(1) > 1 Please see the attached enter image description here

0

There are 0 best solutions below