MongoDB all entries with maximum values in column

Question

I have the data

{"name" : "user1", age : 40 }
{"name" : "user2", age : 45 }
{"name" : "user3", age : 50 }
{"name" : "user4", age : 40 }
{"name" : "user5", age : 40 }
{"name" : "user6", age : 21 }

I want all rows having the maximum age.

Basically fetch all rows whose column value is maximum in the column.

SQL query : SELECT * FROM Person WHERE age = (SELECT max(age) FROM Person)

How can I do the same in MongoDB ? Thank you

Possible duplicate of How can I get the lowest values in a MongoDB collection? — Sede
– Sede, Commented Oct 21, 2016 at 6:59

Sede · Accepted Answer · 2016-10-21 06:58:02Z

1

You can do this with the aggregation framework like this:

db.collection.aggregate([
    { "$group": { 
        "_id": "$age", 
        "docs": { "$push": "$$ROOT" } 
    }},
    { "$sort": { "_id": -1 } },
    { "$limit": 1 }
])

answered Oct 21, 2016 at 6:58

Sede

61.5k20 gold badges159 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sujithvm Over a year ago

Thank you for your response. Can you explain what you are doing there ?

Sede Over a year ago

@sujithvm Please read my other answer here for more details.

Collectives™ on Stack Overflow

MongoDB all entries with maximum values in column

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related