
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
AmitDiwan has Published 10744 Articles

AmitDiwan
115 Views
No, using LIMIT() decreases the bandwidth consumption and it does not increase query speed. Let us see an example and create a collection with documents −> db.demo197.insertOne({"Name":"Chris"}); { "acknowledged" : true, "insertedId" : ObjectId("5e3afde803d395bdc21346d8") } > db.demo197.insertOne({"Name":"Bob"}); { "acknowledged" : true, "insertedId" : ObjectId("5e3afdef03d395bdc21346d9") } > ... Read More

AmitDiwan
518 Views
Let us create a collection with documents −> db.demo196.insertOne( ... { ... ... "Id" : "101", ... "details" : [ ... { ... "FirstName" : "Chris", ... "LastName" : "Brown", ... ... Read More

AmitDiwan
410 Views
To return a list of specific values, use map(). Let us create a collection with documents −> db.demo195.insertOne({"Subject":"MySQL"}); { "acknowledged" : true, "insertedId" : ObjectId("5e3af3f203d395bdc21346d4") } > db.demo195.insertOne({"Subject":"MongoDB"}); { "acknowledged" : true, "insertedId" : ObjectId("5e3af3f703d395bdc21346d5") } > db.demo195.insertOne({"Subject":"Java"}); { "acknowledged" : true, "insertedId" : ... Read More

AmitDiwan
190 Views
Let us first create a collection with documents −> db.demo194.insertOne( ... { ... "_id": 101, ... "details": { ... "otherDetails": { ... "List1": ["MongoDB", "MySQL"], ... "List2": ["Java"], ... ... Read More

AmitDiwan
261 Views
To improve the execution time of a query, use index along with unique:true. Let us create a collection with documents −> db.demo193.createIndex({"LastName":1}, {unique:true}); { "createdCollectionAutomatically" : true, "numIndexesBefore" : 1, "numIndexesAfter" : 2, "ok" : 1 } > db.demo193.insertOne({"FirstName":"John", "LastName":"Doe"}); { "acknowledged" : true, ... Read More

AmitDiwan
238 Views
To group several fields, use $group in MongoDB. Let us create a collection with documents −> db.demo192.insertOne({"Name":"Chris", "Age":22}); { "acknowledged" : true, "insertedId" : ObjectId("5e3adb9f03d395bdc21346cd") } > db.demo192.insertOne({"Name":"David", "Age":21}); { "acknowledged" : true, "insertedId" : ObjectId("5e3adba103d395bdc21346ce") } > db.demo192.insertOne({"Name":"Chris", "Age":22}); { "acknowledged" : true, ... Read More

AmitDiwan
672 Views
To get values of cursor in MongoDB, use hasNext(). Let us create a collection with documents −> db.demo191.insertOne({"EmployeeId":1, "EmployeeName":"Chris Brown"}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ad95303d395bdc21346c5") } > db.demo191.insertOne({"EmployeeId":2, "EmployeeName":"David Miller"}); { "acknowledged" : true, "insertedId" : ObjectId("5e3ad95f03d395bdc21346c6") } > db.demo191.insertOne({"EmployeeId":1, "EmployeeName":"John Doe"}); { ... Read More

AmitDiwan
597 Views
To implement aggregation with multiple keys, use aggregate() along with $group. Let us create a collection with documents −> db.demo190.insertOne( ... { ... ... "DueDate" : ISODate("2020-01-01"), ... "Value" : 10, ... "Name" : "Chris" ... } ...); { "acknowledged" : ... Read More

AmitDiwan
316 Views
To sort by the sum of specified object inside inner array, use $match along with $sort. Let us create a collection with documents −> db.demo189.insertOne( ... { ... "_id" : 100, ... "List" : [ ... { ... ... Read More

AmitDiwan
451 Views
To find same value multiple times, use $where in MongoDB. Let us create a collection with documents −> db.demo188.insertOne( ... { ... "ListOfData":[ ... {"Data": 100}, ... {"Data": 200}, ... {"Data": 100} ... ... Read More