Introduction to Sorting in MongoDB

Sorting is an essential operation in MongoDB that allows you to arrange query results in a specific order. MongoDB supports both ascending and descending sorting based on one or more fields. In this guide, we'll explore how to sort data in MongoDB using sample code.


Ascending Sorting

To perform ascending sorting in MongoDB, you can use the

sort
method with a field name. Here's an example:


db.myCollection.find().sort({ fieldName: 1 })

In the above code,

fieldName
is the name of the field by which you want to sort, and
1
indicates ascending order.


Descending Sorting

Descending sorting is similar to ascending sorting but with the use of

-1
. Here's an example:


db.myCollection.find().sort({ fieldName: -1 })

In this case,

-1
represents descending order, and the results will be sorted in reverse order based on the specified field.


Combining Sorting on Multiple Fields

You can sort data based on multiple fields by providing an array of field and order pairs to the

sort
method. For instance:


db.myCollection.find().sort({ field1: 1, field2: -1 })

In this example, documents will first be sorted in ascending order based on

field1
, and within each
field1
group, they will be sorted in descending order based on
field2
.


Conclusion

Sorting data in MongoDB is an important aspect of data retrieval. Whether you need ascending or descending order or wish to sort by multiple fields, MongoDB provides the necessary tools to help you organize your data for analysis and presentation.