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 query the top N rows in MongoDB, use the aggregation framework with $sort and $limit operators. This approach allows you to sort documents by any field and retrieve only the specified number of top results. Syntax db.collection.aggregate([ { $sort: { fieldName: 1 } }, // 1 for ascending, -1 for descending { $limit: N } // N = number of documents to return ]); Sample Data db.topNRowsDemo.insertMany([ ... Read More
To print a variable at the MongoDB command prompt, you can either reference the variable name directly or use the print() function. Both methods display the variable's value in the shell. Syntax // Declaring and initializing a variable var variableName = value; // Method 1: Direct variable reference variableName; // Method 2: Using print() function print(variableName); Example 1: Integer Variable Declare and initialize an integer variable ? var myIntegerValue = 20; Print the variable using direct reference ? myIntegerValue; 20 Print ... Read More
To find all documents with a field that is NaN in MongoDB, use the $eq operator or direct comparison with NaN value in your query. Syntax db.collection.find({ fieldName: NaN }); Or using the $eq operator: db.collection.find({ fieldName: { $eq: NaN } }); Create Sample Data First, let's create a collection with documents containing various numerical values including NaN ? db.nanDemo.insertMany([ { "Score": 0/0 }, // NaN { "Score": 10/5 }, ... Read More
You can use $in operator instead of $elemMatch on first level array. For simple value matching in arrays, $in provides better performance and cleaner syntax. Syntax db.collection.find({ "arrayField": { $in: ["value1", "value2"] } }); Sample Data Let us create a collection with documents containing first−level arrays ? db.firstLevelArrayDemo.insertMany([ { "StudentName": "Chris", "StudentTechnicalSkills": ["MongoDB", "MySQL", "SQL Server"] }, { ... Read More
To retrieve the first document in a MongoDB collection, use the findOne() method. This returns the first document from the collection in natural insertion order. Syntax db.collectionName.findOne(); // Store in variable and display var result = db.collectionName.findOne(); result; Sample Data db.retrieveFirstDocumentDemo.insertMany([ {"ClientName": "Robert", "ClientAge": 23}, {"ClientName": "Chris", "ClientAge": 26}, {"ClientName": "Larry", "ClientAge": 29}, {"ClientName": "David", "ClientAge": 39} ]); { "acknowledged": true, "insertedIds": [ ... Read More
To search for nested keys in MongoDB, use dot notation to specify the path to the nested field. This allows you to query documents based on values within embedded objects. Syntax db.collectionName.find({"outerField.innerField": "value"}); Sample Data Let us create a collection with nested documents ? db.searchForNestedKeysDemo.insertMany([ { "ClientName": "Larry", "ClientAge": 28, "ClientExtraDetails": { ... Read More
To prevent MongoDB from returning the Object ID while finding a document, you need to set _id to 0 in the projection parameter of the find() method. This excludes the _id field from the query results. Syntax db.collection.find( { query }, { "_id": 0, "field1": 1, "field2": 1 } ); Sample Data Let us first create a collection with a sample document ? db.preventObjectIdDemo.insertOne({ "StudentName": "Chris", "StudentDetails": [ ... Read More
To convert from string to date data type in MongoDB, you can use the ISODate() function within a script that iterates through documents and updates them. This is useful when you have date fields stored as strings that need to be converted to proper date objects. Syntax db.collection.find().forEach(function(doc){ doc.dateField = ISODate(doc.dateField); db.collection.save(doc); }); Create Sample Data Let us first create a collection with documents containing string date values ? db.stringToDateDataTypeDemo.insertMany([ {"CustomerName": "Carol", "ShippingDate": "2019-01-21"}, {"CustomerName": "Bob", ... Read More
To find inside a hash (embedded document) in MongoDB, use dot notation to access nested fields. This allows you to query specific fields within embedded documents using the format "parentField.childField". Syntax db.collection.find({ "embeddedDocument.field": "value" }); Sample Data Let us create a collection with documents containing embedded ClientDetails ? db.hashDemo.insertMany([ { "ClientName": "Larry", "ClientAge": 23, "ClientDetails": { ... Read More
To query MongoDB for datetime values less than the current time, use the $lte operator with new Date() which returns the current timestamp. Syntax db.collection.find({ "dateField": { $lte: new Date() } }); Sample Data db.dateTimeValueLessThanNowDemo.insertMany([ { "CustomerName": "Larry", "CustomerProductName": "Product-1", "ArrivalDate": new ISODate("2017-01-31") }, { ... Read More