Articles → MONGODB → $Min And $Max Operators In Mongodb

$Min And $Max Operators In Mongodb

In this article, we will discuss the $min and $max operators in MongoDB.

Sample Collection

For this article, we will use the following collection: -

Picture showing the sample mongodb collection

$Min Operator

The $min operator updates the value of a field to the specified value if the specified value is less than the current value of the field.

In the above collection, the requirement is to update the value of age to 27 if the value of age is less than 27. So, the query is: -

db.mycollection.updateOne({ _id: ObjectId("6597b8a02695219f3c55e481")},{$min:{age:27}})

Picture showing the output of $min operator in mongodb

$Max Operator

The $max operator updates the value of a field to the specified value if the specified value is greater than the current value of the field.

Consider the following query: -

db.mycollection.updateOne({ _id: ObjectId("6597b8a02695219f3c55e481")},{$max:{age:29}})

In the above collection, the requirement is to update the value of age to 29 because the value 29 is greater than the current value of age i.e., 27.

Picture showing the output of $max operator in mongodb

Posted By -	Karan Gupta

Posted On -	Tuesday, March 19, 2024

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250