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

2 votes145 views1 answer
Filter function using lambda in python
Python
3 votes165 views3 answers
Take pictures from webcam python
Python
0 vote146 views2 answers
Round to nearest multiple of 5 python from both end
Python
3 votes131 views1 answer
Disable images selenium python
Python
0 vote147 views1 answer
Python, importing other scripts from other directories
Python
0 vote143 views1 answer
Lowercase all text in a column
Python
0 vote154 views1 answer
How to make a numpy array of certain values
Python
0 vote184 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python Django
12 votes152 views5 answers
Python create uuid
Python
24 votes152 views6 answers
How to save a pickle file
Python