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 vote207 views1 answer
|select name and description powershell
Python
1 vote218 views1 answer
Django queryset multiple filters
Python
13 votes187 views5 answers
How to find largest number in list python without max
Python
1 vote245 views1 answer
Portscan with python
Python
5 votes210 views1 answer
How to count things in a list python
Python
0 vote185 views2 answers
How to make a leaderboard in python
Python
1 vote215 views1 answer
Python count the frequency of words in a list
Python
1 vote229 views2 answers
Dfs algorithm python
Python
0 vote197 views2 answers
Multiple categories on distploy
Python
11 votes214 views2 answers
Sending whatsapp message using python
Python