Mongodb group by having

#It's the equivalent of the following SQL instruction:
# SELECT COUNT(*) FROM Table
# GROUP BY your_field
# HAVING COUNT(*) > N
query = db.collection.aggregate([

    { 
      "$group": { "_id": "$your_field", #GROUP BY your_field
    			"count": {"$sum":1} }   #COUNT(*)
    },
    
    { "$match": { "count": { "$gt": N } } } #HAVING COUNT(*) > N
])

Similar codes

0 vote235 views1 answer
Install aws sdk ubuntu 20.04 command line
Python
0 vote218 views1 answer
Print pattern a shape in python
Python
1 vote229 views1 answer
Python change name of the imported function
Python
0 vote212 views1 answer
Sendgrid send email to multiple recipients python
Python
-1 vote227 views1 answer
Decimal conversion python
Python
0 vote226 views1 answer
How to pre populate field flask wtforms
Python
0 vote220 views1 answer
Improt kmean
Python
0 vote212 views1 answer
Def form_valid
Python
0 vote213 views1 answer
Rest api error
Python
0 vote246 views1 answer
Pandas melt and stack
Python