php - mysql 高手来看看

Question

如图怎么统计 b_goods 对于的 b_ordermun 总和

Answer 1

select sum(b_ordernum) as sum_ordernums,b_goods from table group by b_goods

通过group by b_goods 实现对b_goods相同编号的记录进行合并，再通过sum求所有b_ordernum的和。

Answer 2

group by b_goods

Answer 3

select b_ordermun ,sum(b_goods) as sum from table group by b_ordermun

Answer 4

谢邀！

select b_goods,count(1) from table group by b_ordermun