Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Find minimum value with MongoDB?
To get the minimum value, use sort() along with limit(1). Let us first create a collection with documents −
> db.findMinimumValueDemo.insertOne({"Value":1004});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cdfd61abf3115999ed51208")
}
> db.findMinimumValueDemo.insertOne({"Value":983});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cdfd61ebf3115999ed51209")
}
> db.findMinimumValueDemo.insertOne({"Value":990});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cdfd622bf3115999ed5120a")
}
> db.findMinimumValueDemo.insertOne({"Value":1093});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cdfd626bf3115999ed5120b")
}
> db.findMinimumValueDemo.insertOne({"Value":10090});
{
"acknowledged" : true,
"insertedId" : ObjectId("5cdfd62fbf3115999ed5120c")
}Following is the query to display all documents from a collection with the help of find() method −
> db.findMinimumValueDemo.find();
This will produce the following output −
{ "_id" : ObjectId("5cdfd61abf3115999ed51208"), "Value" : 1004 }
{ "_id" : ObjectId("5cdfd61ebf3115999ed51209"), "Value" : 983 }
{ "_id" : ObjectId("5cdfd622bf3115999ed5120a"), "Value" : 990 }
{ "_id" : ObjectId("5cdfd626bf3115999ed5120b"), "Value" : 1093 }
{ "_id" : ObjectId("5cdfd62fbf3115999ed5120c"), "Value" : 10090 }Following is the query to find minimum value −
> db.findMinimumValueDemo.find().sort({Value:1}).limit(1);This will produce the following output −
{ "_id" : ObjectId("5cdfd61ebf3115999ed51209"), "Value" : 983 }
Updated on: 30-Jul-2019
216 Views
Advertisements