您的列数是否固定?您的优惠券类型将始终为AIN和ACN吗?在这种情况下，请尝试以下查询

Is your number of columns fixed? Will your voucher type be always AIN and ACN alone. In that case try this query

Select data.VCR_VOUCHER_TYPE, case when (data.VCR_VOUCHER_TYPE = 'AIN') then data.amount else 0  end VCR_Amount1,
case when (data.VCR_VOUCHER_TYPE = 'ACN') then data.amount else 0 end  VCR_Amount2
from
(Select VCR_VOUCHER_TYPE, SUM(VCR_Amount) amount from T_T_voucher group by VCR_VOUCHER_TYPE) data