how to find data from mongodb collection in desending order?

Question

Suppose this is a collection named books in mongodb and the data are as follows.Here I ignore _id. please provide a simple query for finding all books from database where the most costly book's document will comes first.

>{
    "name":"A",
    "cost":100
 }
 {
    "name":"B",
    "cost":1000
 }
 {
    "name":"F",
    "cost":400
 }
 {
    "name":"E",
    "cost":400
 }
 {
    "name":"Z",
    "cost":800
 }

My expected result will be:

>{
     "name":"B",
     "cost":1000
 }
 {
     "name":"Z",
     "cost":800
 }
 {
     "name":"E",
     "cost":400
 }
 {
     "name":"F",
     "cost":400
 }
 {
     "name":"A",
     "cost":100
 }

Md Nazmul Hossain · Answer 1 · 2016-01-16T18:47:52.373

0

please use : .sort({cost:-1}) in your query for showing decending order of collection.

Full query will be :

For node.js :

books.find({}).sort({"cost":-1}).exec(function(err,data){

})

or

db.books.find().sort({"cost":-1})

edited Jan 16 '16 at 18:47

answered Jan 16 '16 at 18:38

Md Nazmul Hossain

2,768
5
26
49

Wasiq Muhammad · Accepted Answer · 2016-01-16T19:08:48.233

0

Try This

  db.books.find({},{"name":1,_id:0,"cost":1}).sort({"cost":-1})

edited Jan 16 '16 at 19:08

answered Jan 16 '16 at 18:41

Wasiq Muhammad

3,080
3
16
29

I think this is helpful, thanks – Koushik Mondal Jan 16 '16 at 19:00
@KoushikMondal if your problem is solved then please choose correct ans and up vote it. – Wasiq Muhammad Jan 16 '16 at 19:10

how to find data from mongodb collection in desending order?

2 Answers2