Examples of MongoDB sort()

To understand sort method in MongoDB we need a collection called students on which we will perform various operations and queries. 

[
{
_id: ObjectId('600f1abb923681e7681ebdce'),
name: 'Akshay',
age: 19
},
{ _id: ObjectId('600f1abb923681e7681ebdcf'), name: 'Bablu', age: 18 },
{
_id: ObjectId('600f1abb923681e7681ebdd0'),
name: 'Rakesh',
age: 21
},
{
_id: ObjectId('600f1abb923681e7681ebdd1'),
name: 'Gourav',
age: 20
}
]

Example 1: Ascending Order

db.student.find().sort({age:1})

Output:

[
{ _id: ObjectId('600f1abb923681e7681ebdcf'), name: 'Bablu', age: 18 },
{
_id: ObjectId('600f1abb923681e7681ebdce'),
name: 'Akshay',
age: 19
},
{
_id: ObjectId('600f1abb923681e7681ebdd1'),
name: 'Gourav',
age: 20
},
{
_id: ObjectId('600f1abb923681e7681ebdd0'),
name: 'Rakesh',
age: 21
}
]

Example 2: Descending Order

db.student.find().sort({age:-1})

Output:

[
{
_id: ObjectId('600f1abb923681e7681ebdd0'),
name: 'Rakesh',
age: 21
},
{
_id: ObjectId('600f1abb923681e7681ebdd1'),
name: 'Gourav',
age: 20
},
{
_id: ObjectId('600f1abb923681e7681ebdce'),
name: 'Akshay',
age: 19
},
{ _id: ObjectId('600f1abb923681e7681ebdcf'), name: 'Bablu', age: 18 }
]

Example 3: Ascending order of student name:

db.student.find().sort({name:1})

Output:

[
{
_id: ObjectId('600f1abb923681e7681ebdce'),
name: 'Akshay',
age: 19
},
{ _id: ObjectId('600f1abb923681e7681ebdcf'), name: 'Bablu', age: 18 },
{
_id: ObjectId('600f1abb923681e7681ebdd1'),
name: 'Gourav',
age: 20
},
{
_id: ObjectId('600f1abb923681e7681ebdd0'),
name: 'Rakesh',
age: 21
}
]

Example 4: Descending order of student name::

db.student.find().sort({name:-1})

Output:

[
{
_id: ObjectId('600f1abb923681e7681ebdd0'),
name: 'Rakesh',
age: 21
},
{
_id: ObjectId('600f1abb923681e7681ebdd1'),
name: 'Gourav',
age: 20
},
{ _id: ObjectId('600f1abb923681e7681ebdcf'), name: 'Bablu', age: 18 },
{
_id: ObjectId('600f1abb923681e7681ebdce'),
name: 'Akshay',
age: 19
}
]

MongoDB – sort() Method

In MongoDB, the sort() method is used to specify the order in which the query returns matching documents from a collection. It allows users to arrange documents in either ascending (1) or descending (-1) order based on the values of one or more fields. In this article, We will learn about the MongoDB sort() method in detail by understanding the various examples and so on.

Similar Reads

MongoDB sort()

The sort() method in MongoDB is used to specify the order in which the query returns matching documents from a given collection. It must be applied to the cursor before retrieving any documents from the database. It takes a document as a parameter that contains a field: value pair that defines the sort order of the result set. The value is 1 or -1 specifying an ascending or descending sort respectively. If a sort returns the same result every time we perform on the same data, then such type of sort is known as a stable sort.  If a sort returns a different result every time we perform on the same data, then such type of sort is known as unstable sort. MongoDB generally performs a stable sort unless sorting on a field that holds duplicate values.   We can use the limit() method with the sort() method, it will return the first m documents, where m is the given limit. MongoDB can find the result of the sort operation using indexes. If MongoDB does not find sort order using index scanning, then it uses the top-k sort algorithm....

Behavior of Sort method in MongoDB

In MongoDB, the sort() method is used to sort the results of a query in either ascending or descending order based on one or more fields. The sort() method takes an object as an argument, where each field to sort by is a key and the value is either 1 for ascending order or -1 for descending order....

Examples of MongoDB sort()

To understand sort method in MongoDB we need a collection called students on which we will perform various operations and queries....

Conclusion

Overall, the sort() method in MongoDB is a powerful tool for arranging query results in either ascending or descending order based on specified fields. Understanding its behavior and optimizing its usage can significantly improve the performance of database queries, especially when dealing with large datasets. By using the sort() method effectively, developers can ensure efficient data retrieval and manipulation in MongoDB....

Contact Us