语法:
db.collection.aggregate([
{$match:{id:1000}},
{$limit:5},
{$group:{_id:"$version", count: {$sum:1}}},
{$sort:{count:-1}}
])
说明:
- collection:查询的集合名称
- $match:匹配条件,可选
- $limit:结果条数,可选
- $group:聚合规则
- $sort:对查询结果排序,-1表示降序
示例:
db.CRM_CSS_REPAIR_ORDER_TABLE.aggregate(
[
{
$group : {
_id : {
key1:"$COLUMN_NAME"
"key2_date_year":{$year:"$produce_date"},
"key3_date_month":{$month:"$produce_date"}
},
count: { $sum: 1 },
min_RECORD_DATE:{$min:'$RECORD_DATE'},
min_purchase_date:{$min:'$purchase_date'}
}
},
{
$sort:{
count:-1
}
}
]
)
参考:
https://docs.mongodb.org/v3.0/reference/operator/aggregation/group/