mongo group query how to keep fields

by

If you want to keep the information about the first matching entries for each group, you can try aggregating like:

    db.test.aggregate([{
      $group: {
         _id : '$name',
         name : { $first: '$name' },
         age : { $first: '$age' },
         sex : { $first: '$sex' },
         province : { $first: '$province' },
         city : { $first: '$city' },
         area : { $first: '$area' },
         address : { $first: '$address' },
         count : { $sum: 1 },
      }
    }]);

More Related Contents:

  1. How to remove array element in mongodb?
  2. Can you specify a key for $addToSet in Mongo?
  3. How to copy a collection from one database to another in MongoDB
  4. What is the default database path for MongoDB?
  5. How to aggregate sum in MongoDB to get a total count?
  6. mongo – couldn’t connect to server 127.0.0.1:27017
  7. What is the best way to store dates in MongoDB?
  8. How to work around the lack of transactions in MongoDB?
  9. Rounding to 2 decimal places using MongoDB aggregation framework
  10. MongoDB – Update or Insert object in array
  11. How to get back the Original document back after aggregation
  12. Why does direction of index matter in MongoDB?
  13. How can I update multiple documents in mongoose?
  14. Matching an array field which contains any combination of the provided array in MongoDB
  15. MongoDB lookup when foreign field is an array of objects
  16. Collision probability of ObjectId vs UUID in a large distributed system
  17. How can I sort into that nulls are last ordered in mongodb?
  18. Changing MongoDB data store directory
  19. Mongoose limit/offset and count query
  20. Read-only file system when attempting mkdir /data/db on Mac [closed]
  21. mongodb move documents from one collection to another collection
  22. How does the order of compound indexes matter in MongoDB performance-wise?
  23. Multiply field by value in Mongodb
  24. How does MongoDB order their docs in one collection? [duplicate]
  25. count array occurrences across all documents with mongo
  26. Group by sum mongodb [duplicate]
  27. How to stop mongo DB in one command
  28. MongoDB: how to count number of keys in a document?
  29. Aggregation with update in mongoDB
  30. Query for a field in an object in array with Mongo?

Leave a Comment