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 vote359 views1 answer
Python PyDrive service account credentials
Python
0 vote298 views1 answer
Python convert dcm to png
Python
0 vote414 views1 answer
Django fixtures. To dump data
Python Django
0 vote313 views1 answer
Command run test keep db python
Python
1 vote383 views1 answer
Unresolved reference 'django'
Python Django
10 votes329 views2 answers
Python - make a copy of a df
Python
1 vote332 views2 answers
Convert string to utf8 python
Python
-1 vote322 views1 answer
Save a file as a pickle
Python
0 vote377 views1 answer
Manage python environment in jupyterlab
Python
0 vote340 views1 answer
Django populate form from database
Python