วิธีเรียงลำดับข้อมูลแบบ descending ใน MongoDB

ไวยากรณ์สำหรับการเรียงลำดับแบบ ascending (น้อยไปมาก):

db.yourCollectionName.find().sort({yourField:1});

ตัวอย่างการใช้งาน

สร้างคอลเลกชัน sortingDemo พร้อมข้อมูลตัวอย่าง:

> db.sortingDemo.insertOne({"Value":100});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e2ed3c9d04998abf006") }
> db.sortingDemo.insertOne({"Value":1});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e31d3c9d04998abf007") }
> db.sortingDemo.insertOne({"Value":150});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e34d3c9d04998abf008") }
> db.sortingDemo.insertOne({"Value":250});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e37d3c9d04998abf009") }
> db.sortingDemo.insertOne({"Value":5});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e3bd3c9d04998abf00a") }
> db.sortingDemo.insertOne({"Value":199});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e3ed3c9d04998abf00b") }
> db.sortingDemo.insertOne({"Value":243});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e44d3c9d04998abf00c") }
> db.sortingDemo.insertOne({"Value":290});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e48d3c9d04998abf00d") }

แสดงข้อมูลทั้งหมด:

> db.sortingDemo.find().pretty();

{"_id" : ObjectId("5c8f8e2ed3c9d04998abf006"), "Value" : 100 }
{"_id" : ObjectId("5c8f8e31d3c9d04998abf007"), "Value" : 1 }
{"_id" : ObjectId("5c8f8e34d3c9d04998abf008"), "Value" : 150 }
{"_id" : ObjectId("5c8f8e37d3c9d04998abf009"), "Value" : 250 }
{"_id" : ObjectId("5c8f8e3bd3c9d04998abf00a"), "Value" : 5 }
{"_id" : ObjectId("5c8f8e3ed3c9d04998abf00b"), "Value" : 199 }
{"_id" : ObjectId("5c8f8e44d3c9d04998abf00c"), "Value" : 243 }
{"_id" : ObjectId("5c8f8e48d3c9d04998abf00d"), "Value" : 290 }

คำสั่งเรียงลำดับแบบ descending (มากไปน้อย):

> db.sortingDemo.find().sort({Value:-1});

{"_id" : ObjectId("5c8f8e48d3c9d04998abf00d"), "Value" : 290 }
{"_id" : ObjectId("5c8f8e37d3c9d04998abf009"), "Value" : 250 }
{"_id" : ObjectId("5c8f8e44d3c9d04998abf00c"), "Value" : 243 }
{"_id" : ObjectId("5c8f8e3ed3c9d04998abf00b"), "Value" : 199 }
{"_id" : ObjectId("5c8f8e34d3c9d04998abf008"), "Value" : 150 }
{"_id" : ObjectId("5c8f8e2ed3c9d04998abf006"), "Value" : 100 }
{"_id" : ObjectId("5c8f8e3bd3c9d04998abf00a"), "Value" : 5 }
{"_id" : ObjectId("5c8f8e31d3c9d04998abf007"), "Value" : 1 }