How can I get maximum value for collections in MongoDB?

Question

I have a mongodb collection like:

db.kids.find()

//results

[

    {name:'tom', age:10},

    {name:'alice', age:12},

    ....

]

I want to have query to get MAX 'age' from this collection like in SQL: SELECT MAX(age) FROM kids WHERE 1

Answer 1

Please use the following query:

db.collection.find().sort({age:-1}).limit(1) // for MAX

db.collection.find().sort({age:+1}).limit(1) // for MIN

Check out this MongoDB tutorial to find more insights into the concepts.