译自:https://docs.mongodb.com/manual/aggregation/
1、创表:
db.orders.insert(
[
{
cust_id:"A123",
amount:500,
status:"A"
},
{
cust_id:"A123",
amount:250,
status:"A"
},
{
cust_id:"B212",
amount:200,
status:"A"
},
{
cust_id:"A123",
amount:300,
status:"D"
}
]
)
2、分组查询:
db.orders.aggregate(
[
{$match:{status:"A"}},
{$group:{_id:"$cust_id",total:{$sum:"$amount"}}}
]
)