Sort Records in MongoDB

The sort() Method

We need to use sort() method to sort documents in MongoDB , it accepts a document field along with their sorting order. To specify sorting order 1 and -1 are used. 1 is used for ascending order while -1 is used for descending order.


Basic syntax of sort() method is given below


Example : Point out the collection testCol has the following data

{ "_id" : ObjectId(5983548781331adf45ec5), "title":"MongoDB Overview", "by":""}
{ "_id" : ObjectId(5983548781331adf45ec6), "title":" ASP.Net Over view ", "by":""}
{ "_id" : ObjectId(5983548781331adf45ec7), "title":" SQL Server 2014", "by":""}

Following example will display the documents sorted by title in descending order.

{"title":" SQL Server 2014"}
{"title":" MongoDB Overview "}
{"title":" SQL Server 2014"}

Please note if you don't specify the sorting preference, then sort() method will display documents in ascending order.

No comments:

Post a Comment

PostgreSQL-Query: Sort result set by specific field values using ORDER BY Clause

Problem: Suppose we have a book_inventory table which has some columns such as id, isbn, title, author, publisher, publish_date, etc.. whe...