$list=M('Miningxm')->field('sum(money) as sspp,sum(drilling) as sspv,sum(trenching) as ssppo,sum(ljdrilling) as sspuuy,sum(ljtrenching) as sspttr,sum(ljprobing) as sspkkj')->group('type')->select();
其中sum里面的是数据库所有该字段的总和取别名。
$list=M('Miningxm')->field('sum(money) as sspp,sum(drilling) as sspv,sum(trenching) as ssppo,sum(ljdrilling) as sspuuy,sum(ljtrenching) as sspttr,sum(ljprobing) as sspkkj')->group('type')->select();
其中sum里面的是数据库所有该字段的总和取别名。
已有 2858 位网友参与,快来吐槽:
发表评论