MongoDB SELECT COUNT GROUP BY

by

This would be the easier way to do it using aggregate:

db.contest.aggregate([
    {"$group" : {_id:"$province", count:{$sum:1}}}
])

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. Multiple join conditions using the $lookup operator
  5. Conditional $sum in MongoDB
  6. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  7. Average Aggregation Queries in Meteor
  8. exclude fields in $lookup aggregation
  9. Find duplicate records in MongoDB
  10. $unwind empty array
  11. How to sum every fields in a sub document of MongoDB?
  12. Add some kind of row number to a mongodb aggregate command / pipeline
  13. Mongo sort on a calculated condition
  14. Find all duplicate documents in a MongoDB collection by a key field
  15. MongoDB sort documents by array elements
  16. MongoDB: Calculate dwell time between every status value change
  17. MongoDB: how to parse date in 3.6 mongoDb version?
  18. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  19. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  20. How to flatten a subdocument into root level in MongoDB?
  21. convert iso date to timestamp in mongo query
  22. Remove Duplicates from MongoDB
  23. Using $slice operator to get last element of array
  24. How to access overall document count during arithmetic aggregation expression
  25. How to deal with the timezone issue when storing dates in utc using mongod?
  26. Sum in nested document MongoDB
  27. MongoDB to Use Sharding with $lookup Aggregation Operator
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment