Bird
Raised Fist0
MongoDBquery~5 mins

$min and $max update operators in MongoDB

Choose your learning style10 modes available
Introduction

These operators help you update a value only if the new value is smaller ($min) or larger ($max) than the current one. This keeps your data accurate without extra checks.

When you want to save the lowest score a player has achieved in a game.
When tracking the highest temperature recorded in a day.
When updating a product price only if the new price is lower or higher than the current price.
When storing the earliest or latest date of an event without overwriting better data.
Syntax
MongoDB
db.collection.updateOne(
  { <filter> },
  { $min: { <field1>: <value1>, ... } }
)

// or

db.collection.updateOne(
  { <filter> },
  { $max: { <field2>: <value2>, ... } }
)

// or both together

db.collection.updateOne(
  { <filter> },
  { $min: { <field1>: <value1>, ... }, $max: { <field2>: <value2>, ... } }
)

You can use $min and $max together or separately in the same update.

If the current field value is missing, $min and $max will set it to the given value.

Examples
This sets Alice's score to 50 only if her current score is higher than 50 or missing.
MongoDB
db.players.updateOne(
  { name: "Alice" },
  { $min: { score: 50 } }
)
This updates Paris's temperature to 30 only if the current temperature is less than 30 or missing.
MongoDB
db.weather.updateOne(
  { city: "Paris" },
  { $max: { temperature: 30 } }
)
This sets the price to 100 only if the current price is higher than 100 or missing, and sets highPrice to 200 only if the current highPrice is less than 200 or missing.
MongoDB
db.products.updateOne(
  { productId: 123 },
  { $min: { price: 100 }, $max: { highPrice: 200 } }
)
Sample Program

This example inserts a player Bob with scores, then updates his highScore only if 90 is higher, and lowScore only if 15 is lower.

MongoDB
db.scores.insertOne({ player: "Bob", highScore: 80, lowScore: 20 })

// Try to update highScore to 90 only if it's higher
// Try to update lowScore to 15 only if it's lower
db.scores.updateOne(
  { player: "Bob" },
  { $max: { highScore: 90 }, $min: { lowScore: 15 } }
)

// Find the updated document
db.scores.findOne({ player: "Bob" })
OutputSuccess
Important Notes

If the field does not exist, $min and $max will create it with the given value.

These operators only work with numbers, dates, and strings that can be compared.

They do not replace the value if the condition is not met, so your data stays safe.

Summary

$min updates a field only if the new value is smaller than the current one.

$max updates a field only if the new value is larger than the current one.

Use them to keep track of minimum or maximum values easily without extra code.

Practice

(1/5)
1. What does the $min update operator do in MongoDB?
easy
A. Updates the field only if the new value is smaller than the current value.
B. Updates the field only if the new value is larger than the current value.
C. Always updates the field with the new value.
D. Deletes the field if the new value is smaller.

Solution

  1. Step 1: Understand the purpose of $min

    The $min operator updates a field only if the new value is smaller than the current value stored in that field.
  2. Step 2: Compare with other options

    $max updates if the new value is larger, and other options do not match the behavior of $min.
  3. Final Answer:

    Updates the field only if the new value is smaller than the current value. -> Option A
  4. Quick Check:

    $min updates only if smaller [OK]
Hint: Remember: $min means update if new value is smaller [OK]
Common Mistakes:
  • Confusing $min with $max behavior
  • Thinking $min always updates the field
  • Assuming $min deletes fields
2. Which of the following is the correct syntax to use $max to update the field score to 90 in MongoDB?
easy
A. { $max: [ score: 90 ] }
B. { $max: score: 90 }
C. { $max: { score: 90 } }
D. { $max: { 'score' => 90 } }

Solution

  1. Step 1: Recall correct MongoDB update syntax

    MongoDB update operators use the format: { $operator: { field: value } }. So $max must be followed by an object with field and value.
  2. Step 2: Check each option

    { $max: { score: 90 } } matches the correct syntax. The options missing braces around the field-value pair or using brackets [] have invalid syntax. { $max: { 'score' => 90 } } uses '=>' which is not valid in MongoDB queries.
  3. Final Answer:

    { $max: { score: 90 } } -> Option C
  4. Quick Check:

    Correct MongoDB update syntax = { $max: { score: 90 } } [OK]
Hint: Use braces { } around field-value pairs in update operators [OK]
Common Mistakes:
  • Using brackets [] instead of braces {}
  • Missing braces around field-value pairs
  • Using arrow syntax '=>' instead of colon ':'
3. Given a document { _id: 1, highScore: 80 }, what will be the document after applying db.collection.updateOne({_id:1}, { $max: { highScore: 75 } })?
medium
A. { _id: 1, highScore: 75 }
B. { _id: 1, highScore: 155 }
C. No document updated
D. { _id: 1, highScore: 80 }

Solution

  1. Step 1: Understand $max behavior on existing value

    The $max operator updates the field only if the new value is greater than the current value. Here, current highScore is 80, new value is 75.
  2. Step 2: Compare values and decide update

    Since 75 is less than 80, the field will NOT be updated. The document remains unchanged.
  3. Final Answer:

    { _id: 1, highScore: 80 } -> Option D
  4. Quick Check:

    $max updates only if new value is larger [OK]
Hint: If new value < current, $max does not update [OK]
Common Mistakes:
  • Assuming $max always updates the field
  • Confusing $max with $min behavior
  • Thinking update fails if condition not met
4. You run this update: db.collection.updateOne({_id: 2}, { $min: { age: 30 } }) but it does not update the document. What could be the reason?
medium
A. The update syntax is incorrect.
B. The current age in the document is less than 30.
C. The document with _id: 2 does not exist.
D. The $min operator requires an array value.

Solution

  1. Step 1: Understand $min update condition

    $min updates the field only if the new value is smaller than the current value.
  2. Step 2: Analyze why update might not happen

    If the current age is already less than 30, the update will not change the document. Other options are incorrect because $min does not require arrays, the syntax is correct, and the question states the update runs but no change occurs.
  3. Final Answer:

    The current age in the document is less than 30. -> Option B
  4. Quick Check:

    $min updates only if new value smaller [OK]
Hint: No update if current value is smaller than $min value [OK]
Common Mistakes:
  • Thinking $min requires array values
  • Assuming syntax error without checking
  • Ignoring existing document values
5. You want to keep track of the lowest and highest temperatures recorded in a MongoDB document with fields minTemp and maxTemp. Which update operation correctly updates both fields when a new temperature temp is 15?
hard
A. { $min: { minTemp: 15 }, $max: { maxTemp: 15 } }
B. { $max: { minTemp: 15 }, $min: { maxTemp: 15 } }
C. { $min: { maxTemp: 15 }, $max: { minTemp: 15 } }
D. { $set: { minTemp: 15, maxTemp: 15 } }

Solution

  1. Step 1: Understand the goal for minTemp and maxTemp

    We want minTemp to update only if the new temperature is lower, so use $min. For maxTemp, update only if new temperature is higher, so use $max.
  2. Step 2: Check each option for correct operator usage

    { $min: { minTemp: 15 }, $max: { maxTemp: 15 } } correctly uses $min for minTemp and $max for maxTemp. { $max: { minTemp: 15 }, $min: { maxTemp: 15 } } and { $min: { maxTemp: 15 }, $max: { minTemp: 15 } } swap operators incorrectly. { $set: { minTemp: 15, maxTemp: 15 } } always sets both fields to 15, ignoring previous values.
  3. Final Answer:

    { $min: { minTemp: 15 }, $max: { maxTemp: 15 } } -> Option A
  4. Quick Check:

    Use $min for minTemp and $max for maxTemp [OK]
Hint: Use $min for minimum and $max for maximum fields [OK]
Common Mistakes:
  • Swapping $min and $max operators
  • Using $set which overwrites values blindly
  • Updating wrong fields with wrong operators
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard