- // SQL Here
- db.getCollection('wechat_message').aggregate(
- [
- { $project : { day : {$substr: ["$sendTime", 0, 10] }}},
- { $group : { _id : "$day", number : { $sum : 1 }}},
- { $sort : { _id : -1 }}
- ]
- )
- // Result Here
- "result" : [
- /* 1 */
{
"_id" : "2017-09-29",
"number" : 8.0
}
/* 2 */
{
"_id" : "2017-09-28",
"number" : 7.0
}
/* 3 */
{
"_id" : "2017-09-27",
"number" : 2.0
} - ]
- 转载自: http://qiaolevip.iteye.com/blog/2226312
mongodb 聚合查询每天统计
最新推荐文章于 2024-03-11 20:45:03 发布