How to find min value in mongodb

by

You can use a combination of sort and limit to emulate min:

> db.foo.insert({a: 1})
> db.foo.insert({a: 2})
> db.foo.insert({a: 3})
> db.foo.find().sort({a: 1}).limit(1) 
{ "_id" : ObjectId("4df8d4a5957c623adae2ab7e"), "a" : 1 }

sort({a: 1}) is an ascending (minimum-first) sort on the a field, and we then only return the first document, which will be the minimum value for that field.

EDIT: note that this is written in the mongo shell, but you can do the same thing from C# or any other language using the appropriate driver methods.

More Related Contents:

  1. How to replace substring in mongodb document
  2. How does MongoDB deal with concurrent updates?
  3. Random record from MongoDB
  4. Find in Double Nested Array MongoDB
  5. MongoDB: upsert sub-document
  6. Add new field to every document in a MongoDB collection
  7. Check that Field Exists with MongoDB
  8. Find MongoDB records where array field is not empty
  9. How do I update Array Elements matching criteria in a MongoDB document?
  10. Get a count of total documents with MongoDB when using limit
  11. ‘Failed to unlink socket file” error in MongoDB 3.0
  12. To what level does MongoDB lock on writes? (or: what does it mean by “per connection”
  13. Mongo order by length of array
  14. Best practice to maintain a mgo session
  15. MongoDB group by array inner-elements
  16. Exception: can’t convert from BSON type EOO to Date
  17. Mongodb Aggregation Framework: Does $group use index?
  18. How to return just the nested documents of an array from all documents
  19. Using MongoDB $pull to delete documents within an Array
  20. MongoDB print distance between two points
  21. mgo – query performance seems consistently slow (500-650ms)
  22. How to solve mongoDB related issue efficiently? [closed]
  23. Geospatial $near within current document field value
  24. Getting a distinct aggregation of an array field across indexes
  25. How to get back the new value after an update in a embedded array?
  26. What is the difference between save and insert in Mongo DB?
  27. Searching string with special characters in MongoDB document
  28. How to filter fields from a mongo document with the official mongo-go-driver
  29. MongoDB not equal to
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment