首页 > 数据库 >mongodb聚合分组返回最新一条和count distinct查询

mongodb聚合分组返回最新一条和count distinct查询

时间:2022-10-26 14:00:38浏览次数:43  
标签:count group uid distinct mongodb id

db.collection.aggregate([
{
$group:{
"_id": "$city",
"unique_count": {
$addToSet: "$zipcode"
}
}
},
{
$project:{
"distinct_zipcodes":{
$size: "$unique_count"
}
}
}
]);

db.some_coll.aggregate([
{$match: {$or: [{"send_uid": 1}, {"receive_uid": 1}]}},
{$group: {_id: "$session_name", last_msg: {$last: "$$ROOT"}}},
])

标签:count,group,uid,distinct,mongodb,id
From: https://www.cnblogs.com/wangdonghua/p/16828108.html

相关文章