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 vote243 views1 answer
Python assertRaises with class property
Python
0 vote673 views1 answer
Pandas calculate same day 3 months ago dateoffset
Python
0 vote285 views1 answer
Copy any files from one folder to another folder in python
Python
12 votes258 views6 answers
Intersection of two lists python
Python
24 votes248 views3 answers
Selenium python
Python
1 vote275 views1 answer
_set in django
Python
0 vote234 views2 answers
Print 2 letter python
Python
0 vote253 views1 answer
Https://raw.githubusercontent.com/tim-yao/lighthouse-ci/d32f465bb6cda08ded4ce25c88c43a3103e4940a/.browserslistrc
Python
0 vote296 views1 answer
Add x=y line to scatter plot python
Python
0 vote243 views1 answer
How to put 2 code n 1 line in python
Python