本文由 发布,转载请注明出处,如有问题请联系我们! 发布时间: 2021-05-13group中sum的值如何获取?Tp5-Mysql-PHP
加载中group-sum如何获取多条数据的sum值。
在thinkphp中正确写法应该是下面这样的
->field('sum(wareqty) as wareqty,wareid')
之后获取的数据就会是以wareid来区分去重后统计到的sum值如下图
[0] => array(3) { ["wareqty"] => string(8) "3.000000" ["wareid"] => string(6) "107695" ["ROW_NUMBER"] => string(1) "1" } [1] => array(3) { ["wareqty"] => string(9) "12.000000" ["wareid"] => string(6) "107539" ["ROW_NUMBER"] => string(1) "2" } [2] => array(3) { ["wareqty"] => string(8) "5.000000" ["wareid"] => string(6) "101401" ["ROW_NUMBER"] => string(1) "3" } [3] => array(3) { ["wareqty"] => string(8) "4.000000" ["wareid"] => string(6) "107106" ["ROW_NUMBER"] => string(1) "4" }
点赞(0)