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 vote319 views1 answer
Bash python csv to json
Python
0 vote347 views2 answers
Computation failed in `stat_flow()`:
Python
23 votes355 views6 answers
Dict python
Python
4 votes340 views2 answers
Pil python image
Python
0 vote323 views1 answer
Python indent selection
Python
6 votes315 views2 answers
Kill port django
Python
0 vote290 views1 answer
Lims
Python
0 vote289 views10 answers
Logistic Regression with a Neural Network mindset python example
Python
1 vote311 views1 answer
How to make a instagram report bot python
Python
0 vote348 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python