这要怎么办啊
select
substring(cmis_code_money_detail.交易卡号,4,2)卡类型,
SUM(case when cmis_code_money_detail.支付方式=0 then cmis_code_money_detail.交易金额 else 0 end)现金,
SUM(case when cmis_code_money_detail.支付方式=1 then cmis_code_money_detail.交易金额 else 0 end)pos,
SUM(case when cmis_code_money_detail.支付方式=2 then cmis_code_money_detail.交易金额 else 0 end)其他
from cmis_code_money_detail
where cmis_code_money_detail.交易类型 in (1,3)
group by substring(cmis_code_money_detail.交易卡号,4,2)