Mongo先分组再去重

db.bizEventReport2019.aggregate([
{$match:{event_id: "1002083", created_time: {"$gte":"2019-03-19 00:00:00", "$lte":"2019-03-20 23:59:59"}, app: "xyf"}}
,{$group:{_id:{"version_code":"$version_code","token": "$token"}}}
,{$group:{_id:{"version_code":"$_id.version_code"},"amount":{"$sum": 1}}}
,{$project:{"_id": 0, "version_code": "$_id.version_code", "amount": 1}}
])

命令执行后结果

转载于:https://www.cnblogs.com/godlove/p/10606302.html