Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
To perform group and distinct operations together in MongoDB, use the $group aggregation stage with $addToSet operator. This approach groups documents while collecting distinct values from specified fields in a single query. Syntax db.collection.aggregate([ { $group: { _id: null, distinctField1: { $addToSet: "$fieldName1" }, distinctField2: { $addToSet: "$fieldName2" }, ... Read More
To query a collection named "version" in MongoDB, use the getCollection() method with the collection name as a string parameter. This is necessary because "version" is a reserved word in MongoDB shell. Syntax db.getCollection("version").find(); db.getCollection("version").insertOne({document}); Create the Collection First, create a collection named "version" ? db.createCollection("version"); { "ok" : 1 } Insert Sample Data Insert multiple version documents using insertMany() ? db.getCollection("version").insertMany([ {"VersionName": "1.0"}, {"VersionName": "1.1"}, {"VersionName": "1.2"} ]); ... Read More
The collMod command allows you to modify options for an existing collection or update view definitions in MongoDB. You can execute this command using runCommand() to change collection behavior and properties. Syntax db.runCommand({ collMod: "collectionName", option: value }); Sample Data Let us first create a collection with sample documents ? db.demo13.insertMany([ {"StudentFirstName": "Chris"}, {"StudentFirstName": "David"}, {"StudentFirstName": "Bob"} ]); { "acknowledged": true, ... Read More
To perform nested searches in MongoDB, use the $and operator combined with $or to create complex query conditions. This allows you to match documents that satisfy multiple criteria with optional alternative conditions. Syntax db.collection.find({ $and: [ { field1: "value1" }, { field2: "value2" }, { $or: [ { field3: "option1" }, ... Read More
To insert an array element with a condition in MongoDB, use the $push operator combined with the $ positional operator to add new elements to nested arrays when specific conditions are met. Syntax db.collection.update( {"arrayField.conditionField": "value"}, {$push: {"arrayField.$.targetArray": newElement}} ); Sample Data db.demo11.insertOne({ "ListOfStudent": [ { "StudentName": "Chris", "ListOfScore": ... Read More
To query a single field in MongoDB, use the find() method with projection. Projection allows you to specify which fields to include or exclude from the query results. Syntax db.collection.find({}, { "fieldName": 1, "_id": 0 }); Sample Data Let us first create a collection with documents ? db.demo10.insertMany([ { "StudentId": 101, "StudentName": "Chris" }, { "StudentId": 102, "StudentName": "David" }, { "StudentId": 103, "StudentName": "Bob" } ]); { "acknowledged": true, ... Read More
In MongoDB aggregation, the $avg operator returns -Infinity when calculating the average of values that include -Infinity. This occurs because any arithmetic operation involving -Infinity propagates the infinite value. Syntax db.collection.aggregate([ { $group: { "_id": "$groupField", "average": { $avg: "$numericField" } } } ]); Sample Data ... Read More
Yes, MongoDB can index null values. When you create an index on a field, MongoDB includes documents where that field is null or missing in the index. This allows efficient queries on null values using the index. Syntax db.collection.createIndex({"fieldName": 1}) db.collection.find({"fieldName": null}) Create Sample Data First, create a unique index on the "Value" field and insert documents with null values ? db.demo170.createIndex({"Value": 1}, {unique: true}); { "createdCollectionAutomatically": true, "numIndexesBefore": 1, "numIndexesAfter": 2, "ok": 1 } db.demo170.insertMany([ ... Read More
To fetch all the document IDs from a MongoDB collection, use the find() method with projection to return only the _id field by excluding other fields. Syntax db.collection.find({}, {"fieldName": 0}); // OR db.collection.find({}, {"_id": 1}); Sample Data Let us create a collection with sample documents ? db.demo169.insertMany([ {"StudentName": "Chris"}, {"StudentName": "Bob"}, {"StudentName": "David"} ]); { "acknowledged": true, "insertedIds": [ ObjectId("5e36975e9e4f06af551997d7"), ... Read More
To return only specific fields (phone numbers) as an array in MongoDB, use the distinct() method to extract unique values from nested fields across all documents in a collection. Syntax db.collection.distinct("field.path") Sample Data Let us create a collection with documents − db.demo166.insertMany([ { "details": { "UserName": "Chris", "UserAge": 29, ... Read More