MySQL SUM()函数按条件求和（转）

原文：https://blog.csdn.net/fu_fei_wen/article/details/78646410

• 一般求和

copyselect sum(money) from user group by id;

• 按条件求和

copyselect sum(if(type=1,money,0)) from user group by id;