mysql 转写 mongo 语句. group by 多字段!

之前一直用mysql,但在业务中增加了mongo 对于 mongo不熟悉。属于边用边看的!

SELECT `*`,GROUP_CONCAT(`invoice_number`) as `invoice_number_all`,ROUND(SUM(`invoice_amount`)/100,2) as `invoice_amount_all`,ROUND(SUM(`premium_amount`)/100,2) as `premium_amount_all`  FROM `t_invoice` WHERE `id` != 0  GROUP BY `insurer_id`,`region_id`,`invoice_company_id`,`data_type`,`invoice_date`,`invoice_remark` ORDER BY `invoice_date` DESC LIMIT 0,15

上面是原sql语句。
我看聚合后写了个

db.t_invoice.aggregate(
{
    "$group": {
        _id: {
            insurer_id:"$insurer_id",
            region_id: "$region_id",
            invoice_company_id:"$invoice_company_id",
            data_type: "$data_type",
            invoice_date: "$invoice_date",
            invoice_remark: "$invoice_remark",
            },
            count:{$sum:1}
        }
    }
})

但是我不知道如何增加字段
image.png
得出结果也不是我想要的,更另说mysql的拼接 计算写法了

阅读 1.7k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题