MongoDB作为当前最流行的非关系型数据库,能通过嵌套子文档,实现一对多的关联关系。应用开发中,常会遇到对嵌套子文档结构的记录,进行分组汇总,如有数据:
{
"warehouseNsId":"10","brandId":37,"financeOwnerId":1231882808817905665,"amount":0,"items":[ {"goodsNsId":"1353","price":"256.00","count":3}, {"goodsNsId":"1799","price":"254.80","count":6}, {"goodsNsId":"1353","price":"256.00","count":10} ] },{ "warehouseNsId":"15","brandId":35,"financeOwnerId":1231882808817905600,"amount":0,"items":[ {"goodsNsId":"1327","price":"238.00","count":17}, {"goodsNsId":"1539","price":"154.80","count":25}, {"goodsNsId":"1327","price":"238.00","count":13}, {"goods |