--MOB1,一个月后再来查询 select sum(bad_monery) `不良余额`,sum(putout_amt) `发放月金额` from ( select (case when is_buding = 1 then balance else 0 end) `bad_monery`,putout_amt from jieju where date_format('ds','yyyy-MM') = '2019-10'
--数据都按天存放,过滤出当月的即可 and date_format('putout_date','yyyy-MM') = '2019-10' ) t1 --MOB2,两个月后再来查询 select sum(bad_monery) `不良余额`,sum(putout_amt) `发放月金额` from ( select (case when is_buding = 1 then balance else 0 end) `bad_monery`,putout_amt from jieju where date_format('ds','yyyy-MM') = '2019-10'
--数据都按天存放,过滤出当月的即可 and date_format('putout_date','yyyy-MM') = '2019-10' ) t1