获取哪个mysql的列的总和

Question

获取mysql列的总和我正在试着做

bid amount  |color
100         | Red
200         | Blue
200         | Red
10         | Blue
100         | Red

按颜色获取投标金额总和对于红色和蓝色和

Answer 1

您只想要聚合吗？

select color, sum(bid_amount) total_bid_amount
from mytable
group by color