get max value in mongoose

Question

how to get maximum value in mongoose query . in SQL it is easy

SELECT MAX(LAST_MOD) FROM table1
Where field1=1

i want Equivalent of above SQL code in mongoose(node.js)

Answer 1

It works perfectly fine.

Model.findOne().sort({
        "field": -1
    });

Answer 2

You can use this, for returning one record in collection (for example Goods):

Goods
   .find({})
   .select({"price"})
   .sort({"price" : -1})
   .limit(1)
   .exec(function(err, doc){
      let max_price = doc[0].price;
});