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

5 votes124 views3 answers
Multiple variables in for loop python
Python
24 votes108 views1 answer
Get wd in python
Python
2 votes111 views1 answer
Fyit download
Python
1 vote128 views1 answer
Exit all threads from within a thread python
Python
5 votes111 views1 answer
How to round to 2 decimals with Python?
Python
0 vote114 views1 answer
Use miraculous with enviroment variable token
Python
5 votes117 views1 answer
How to rezize image in python tkinter
Python
-1 vote119 views1 answer
How to join two dataframe in pandas based on two column
Python
21 votes113 views5 answers
How to get input from list in python
Python
1 vote109 views1 answer
Skip header in csv python
Python