MongoDB query to add up the values of a specific field in documents

Let us create a collection with documents −

> db.demo677.insertOne({Value:10});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea421f404263e90dac943f8")
}
> db.demo677.insertOne({Value:50});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea421f704263e90dac943f9")
}
> db.demo677.insertOne({Value:20});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea421fa04263e90dac943fa")
}
> db.demo677.insertOne({Value:20});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea421fe04263e90dac943fb")
}

Display all documents from a collection with the help of find() method −

> db.demo677.find();

This will produce the following output −

{ "_id" : ObjectId("5ea421f404263e90dac943f8"), "Value" : 10 }
{ "_id" : ObjectId("5ea421f704263e90dac943f9"), "Value" : 50 }
{ "_id" : ObjectId("5ea421fa04263e90dac943fa"), "Value" : 20 }
{ "_id" : ObjectId("5ea421fe04263e90dac943fb"), "Value" : 20 }

Following is the query to add up the values of a specific field −

> db.demo677.aggregate({ $group: { _id : null, sum : { $sum: "$Value" } } });

This will produce the following output −

{ "_id" : null, "sum" : 100 }

AmitDiwan

Published on 13-May-2020 10:08:02

• Related Questions & Answers
• MongoDB query to add multiple documents
• Find MongoDB documents that contains specific field?
• MongoDB query to limit the returning values of a field?
• MongoDB query to match documents with array values greater than a specific value
• MongoDB query to collectively match intersection of documents against a field
• Find documents that contains specific field in MongoDB?
• MongoDB query to get specific list of names from documents where the value of a field is an array
• Fetch specific field values in MongoDB
• MongoDB query to fetch a specific document rom documents with field value set using NumberInt()?
• MongoDB aggregation to fetch documents with specific field value?
• Get count of array elements from a specific field in MongoDB documents?
• How to add a new field to all the documents in a MongoDB collection
• MongoDB query to display documents with a specific name irrespective of case
• MongoDB query to update each field of documents in collection with a formula?
• MongoDB query to implement nor query to fetch documents except a specific document