Sort MongoDB documents in descending order

To sort documents, use sort() along with find(). Let us create a collection with documents −

> db.demo630.insertOne({"Value":10});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e9b080e6c954c74be91e6ba")
}
> db.demo630.insertOne({"Value":200});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e9b08116c954c74be91e6bb")
}
> db.demo630.insertOne({"Value":40});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e9b08146c954c74be91e6bc")
}
> db.demo630.insertOne({"Value":60});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e9b08176c954c74be91e6bd")
}

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

> db.demo630.find();

This will produce the following output −

{ "_id" : ObjectId("5e9b080e6c954c74be91e6ba"), "Value" : 10 }
{ "_id" : ObjectId("5e9b08116c954c74be91e6bb"), "Value" : 200 }
{ "_id" : ObjectId("5e9b08146c954c74be91e6bc"), "Value" : 40 }
{ "_id" : ObjectId("5e9b08176c954c74be91e6bd"), "Value" : 60 }

Following is the query to sort −

> db.demo630.find().sort({Value:-1});

This will produce the following output −

{ "_id" : ObjectId("5e9b08116c954c74be91e6bb"), "Value" : 200 }
{ "_id" : ObjectId("5e9b08176c954c74be91e6bd"), "Value" : 60 }
{ "_id" : ObjectId("5e9b08146c954c74be91e6bc"), "Value" : 40 }
{ "_id" : ObjectId("5e9b080e6c954c74be91e6ba"), "Value" : 10 }

AmitDiwan

Published on 12-May-2020 07:18:47

• Related Questions & Answers
• How to perform descending order sort in MongoDB?
• Sort the MongoDB documents in ascending order with aggregation?
• How to order by timestamp (descending order) in MongoDB
• Sort list elements in descending order in C#
• Sort an array in descending order using C#
• How to sort TreeSet in descending order in Java?
• How can we sort MySQL output in descending order?
• C# program to sort an array in descending order
• 8085 Program to perform bubble sort in descending order
• 8085 Program to perform selection sort in descending order
• C program to sort an array in descending order
• How to sort an ArrayList in Java in descending order?
• Sort by date & time in descending order in MySQL?
• How to sort an ArrayList in Descending Order in Java
• Sort ArrayList in Descending order using Comparator with Java Collections