select proid,sum(num),sum(total) from table where orderid in (2,4) group b
y proid;测试结果:
+-------+----------+------------+
| proid | sum(num) | sum(total) |
+-------+----------+------------+
| 2 | 1134 | 11340 |
| 3 | 2324 | 69720 |
+-------+----------+------------+
y proid;测试结果:
+-------+----------+------------+
| proid | sum(num) | sum(total) |
+-------+----------+------------+
| 2 | 1134 | 11340 |
| 3 | 2324 | 69720 |
+-------+----------+------------+
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货