mysql同一个分组条件,不同查询条件分开统计
适用于统计多个查询条件例如:查询总金额,线上金额、线下金额select sum(t3.fee) as fee,sum(if(t3.payway in (0,3),t3.fee,0)) as sum1,sum(if(t3.payway in (1,2,4),t3.fee,0)) as sum2 from t_busi_waybill t1
LEFT JOIN t_busi_order_waybill...
原创
2018-07-07 14:30:07 ·
4320 阅读 ·
0 评论