i would only like to retrieve results whose count is greater than 1 with this request, how can i do that ?
db.collection.aggregate([{$group:{_id:"$id"},count:{$sum:1}}]);
Thx in advance
Asked
Active
Viewed 527 times
0
L.G
- 1,458
- 4
- 14
- 24
-
Add $match stage with greater than 0 comparison to keep matching documents. Something like `{$match:{count:{$gt:0}}}` – s7vr Jul 25 '18 at 09:27
-
You can place match after group in the aggregation pipeline ? – L.G Jul 25 '18 at 09:32
-
Yes. Aggregation takes sequence of pipelines. – s7vr Jul 25 '18 at 09:33
-
thanks for your help – L.G Jul 25 '18 at 09:37
-
Could you give me the syntax ?... – L.G Jul 25 '18 at 10:13