Question

php 分组前求和

sql 查出数据，把相同channel 的值求和，让后进行分组显示。改如何操作。。求大神讲解。
注 ：按条件查询15 号 16 数据，先得出registered_user_amount 为6 authentication_user_amount 位5 等，让后分组 显示一条

Answer 1

select channel, sum(registered_user_amount) as sum1, sum(authentication_user_amount) as sum2, sum(payment_user_amount) as sum3 from 表名 group by channel;

追问

是这样 感谢

Answer 2

select sum(test) from tb group by channel;