mongodb的排序方法

1. mongodb 的sort() 方法

语法

#按照key1进行升序排列
db.COLLECTION_NAME.find().sort({key1:1})
#按照key1进行降序排列
db.COLLECTION_NAME.find().sort({key1:-1})

实例

#查询myCollection集合按age字段降序排列
> db.myCollection.find({}).sort({"age":-1})
{ "_id" : ObjectId("5a913296113385ab59f380b5"), "name" : "xxx", "age" : 54 }
{ "_id" : ObjectId("5a91328a113385ab59f380b4"), "name" : "hhh", "age" : 28 }
{ "_id" : ObjectId("5a903519d5f9a583d52a7f7b"), "name" : "ddd", "age" : 19 }
{ "_id" : ObjectId("5a9034fdd5f9a583d52a7f78"), "name" : "eee", "address" : "万年花城" }
{ "_id" : ObjectId("5a90352b113385ab59f380b2"), "name" : "wfei" }
{ "_id" : ObjectId("5a903546113385ab59f380b3"), "name" : "ccc" }


#查询myCollection集合按age字段升序排列
> db.myCollection.find({}).sort({"age":1})
{ "_id" : ObjectId("5a9034fdd5f9a583d52a7f78"), "name" : "eee", "address" : "万年花城" }
{ "_id" : ObjectId("5a90352b113385ab59f380b2"), "name" : "wfei" }
{ "_id" : ObjectId("5a903546113385ab59f380b3"), "name" : "ccc" }
{ "_id" : ObjectId("5a903519d5f9a583d52a7f7b"), "name" : "ddd", "age" : 19 }
{ "_id" : ObjectId("5a91328a113385ab59f380b4"), "name" : "hhh", "age" : 28 }
{ "_id" : ObjectId("5a913296113385ab59f380b5"), "name" : "xxx", "age" : 54 }
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容