$gt
On this page
$gt$gtselects those documents where the value of the specified field is greater than (i.e.>) the specified value.For most data types, comparison operators only perform comparisons on fields where the BSON type matches the query value's type. MongoDB supports limited cross-BSON comparison through Type Bracketing.
Compatibility
You can use $gt for deployments hosted in the following
environments:
MongoDB Atlas: The fully managed service for MongoDB deployments in the cloud
MongoDB Enterprise: The subscription-based, self-managed version of MongoDB
MongoDB Community: The source-available, free-to-use, and self-managed version of MongoDB
Syntax
The $gt operator has the following form:
{ field: { $gt: value } }
Examples
db.inventory.find( { qty: { $gt: 20 } } )
This query will select all documents in the inventory collection
where the qty field value is greater than 20.
Consider the following example that uses the $gt
operator with a field from an embedded document:
db.inventory.update( { "carrier.fee": { $gt: 2 } }, { $set: { price: 9.99 } } )
This update() operation will set
the value of the price field in the first document found containing the
embedded document carrier whose fee field value is
greater than 2.
To set the value of the price field in all documents containing the
embedded document carrier whose fee field value is greater than 2,
specify the multi:true option in the update() method:
db.inventory.update( { "carrier.fee": { $gt: 2 } }, { $set: { price: 9.99 } }, { multi: true } )