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

15 votes110 views3 answers
Python get input from console
Python
1 vote115 views2 answers
Python wget download
Python
3 votes124 views2 answers
Priting matrix using np truncating the output
Python
2 votes94 views2 answers
Python django query
Python
1 vote98 views1 answer
Sns title
Python
0 vote106 views1 answer
Python skip input
Python
11 votes115 views6 answers
Pandas group by count
Python
1 vote101 views2 answers
Python print array vertically
Python
0 vote88 views1 answer
Np.argmax python could not be evaluated
Python
0 vote114 views1 answer
Python form html
Python