by mango怎么group_在mongodb中用“group by”选择Max()

我已经创建了Mongo Collection，如下所示。

{ "_id" : ObjectId("4fb36bfd3d1c88bfa15103b1"), "name" : "bob", "value" : 5 }

{ "_id" : ObjectId("4fb36c033d1c88bfa15103b2"), "name" : "bob", "value" : 3 }

{ "_id" : ObjectId("4fb36c063d1c88bfa15103b3"), "name" : "bob", "value" : 7 }

{ "_id" : ObjectId("4fb36c0c3d1c88bfa15103b4"), "name" : "john", "value" : 2 }

{ "_id" : ObjectId("4fb36c103d1c88bfa15103b5"), "name" : "john", "value" : 4 }

{ "_id" : ObjectId("4fb36c143d1c88bfa15103b6"), "name" : "john", "value" : 8 }

{ "_id" : ObjectId("4fb36c163d1c88bfa15103b7"), "name" : "john", "value" : 6 }

然后通过使用以下代码，我将其按名称和max(value)分组，

db.table1.group(

{key: {name:true},

reduce: function(obj,prev) {

if (prev.maxValue < obj.value) {

prev.maxValue = obj.value;

}

},

initial: { maxValue: 0 }}

);

结果显示为

[

{

"name" : "bob",

"maxValue" : 7

},

{

"name" : "john",

"maxValue" : 8

}

]

聚合框架简单得多。您可以使用聚合框架通过以下代码获得相同的结果。

db.table1.aggregate(

{$group:{_id:"$name", "maxValue": {$max:"$value"}}}

);