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

11 votes141 views2 answers
Save machine learning model
Python
0 vote131 views1 answer
How to write flow of execution in python
Python
3 votes146 views1 answer
How to append to front of the list using def method in python 3
Python
1 vote177 views5 answers
How to find avrage python
Python
2 votes155 views1 answer
Save df to txt
Python
5 votes129 views5 answers
Docstring in python
Python
24 votes135 views5 answers
Python sort descending
Python
6 votes139 views6 answers
Best ide for python
Python
4 votes118 views1 answer
ModuleNotFoundError: No module named 'exceptions'
Python
0 vote160 views1 answer
Python launch ipython from script
Python