具体案例:
mysql的手册中对SUM函数的介绍非常简单和含糊, 今天在搜资料的时候发现SUM函数的参数还可以加入条件判断. |
总结语句 SUM( IF( 类别编号 =1, 支出金额, 0 ) ) AS 其它支出,
IF 其实是mysql的一个流程控制函数, |
项目中实战sql:
select sum(quantity) as '总票数', sum(charge_weight) as '总重量', sum(keep_amount) as '总保价费', sum(balance_amount) as '总结算金额', sum(if(channel_code like '%GUOGUO%',quantity,0)) as '裹裹票数', sum(if(channel_code like '%GUOGUO%',charge_weight,0)) as '裹裹重量', sum(if(channel_code like '%GUOGUO%',balance_amount,0)) as '裹裹结算金额' from wd_income_details where income_type = 1 group by source_org_code; 含义:先分组 每组中满足if条件的进行sum
|