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

6 votes186 views2 answers
Flask form options
Python
0 vote174 views1 answer
Tensorflow python 3.9
Python
2 votes195 views1 answer
Python click buttons on websites
Python
0 vote182 views1 answer
F2 polar or nonpolar
Python
97 votes198 views6 answers
Download python
Python
2 votes193 views1 answer
Django template tag to display current year
Python
17 votes178 views3 answers
Change column names with number pd dataframe
Python
11 votes188 views1 answer
Pandas xlsx to csv
Python
0 vote186 views2 answers
Torch tensor to pandas dataframe
Python
3 votes214 views1 answer
Python bounding box on image
Python