MongoDB　group 使用　$first 获取指定字段

最新推荐文章于 2024-03-17 14:00:08 发布

熊先生的博客

最新推荐文章于 2024-03-17 14:00:08 发布

阅读量1.5w

点赞数 4

分类专栏： MongoDB 文章标签： mongodb

本文链接：https://blog.csdn.net/xiojing825/article/details/78362972

版权

MongoDB 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

原测试数据：

{ "_id" : ObjectId("59a221054afa291a4e0a974d"), "name" : "jack", "age" : 16, "sex" : "male"}
{ "_id" : ObjectId("59a221144afa291a4e0a974e"), "name" : "lucy", "age" : 16, "sex" : "female"}
{ "_id" : ObjectId("59a221304afa291a4e0a9750"), "name" : "lili", "age" : 18, "sex" : "female" }
{ "_id" : ObjectId("59b0a98bf4eee74a4359353d"), "name" : "jack", "age" : 16, "sex" : "male"}
{ "_id" : ObjectId("59e5c25a483b8642c5ac3ded"), "name" : "jame", "age" : 17, "sex" : "unknown"}

以age 和sex分组。获取age, sex, name字段

 db.a_test.aggregate([{'$group':{_id:{age:"$age",sex:"$sex"}, name:{$first:"$name"}}},{'$project':{_id:false,age:"$_id.age",sex:"$_id.sex", name:"$name"}}]);

获取到的数据

{ "age" : 17, "sex" : "unknown", "name" : "jame" }
{ "age" : 18, "sex" : "female", "name" : "lili" }
{ "age" : 16, "sex" : "female", "name" : "lucy" }
{ "age" : 16, "sex" : "male", "name" : "jack" }