如何将一列值显示为两列值 [英] How to display one column values into two column values

问题描述

我正在使用表T_T_VOUCHER中的两列...

Hi,
I''m using two columns in Table T_T_VOUCHER...

VCR_VOUCHER_TYPE   VCR_AMOUNT
AIN                1000
AIN                2000
AIN                -1000
ACN                4000
ACN                5000
ACN                -2000

我想要一个过程，其中我想将两列显示为三列，如下所示

I want a procedure in which I want to display the two columns into three columns as given below

VCR_VOUCHER_TYPE    VCR_AMOUNT1    VCR_AMOUNT2
          AIN              2000            0
          ACN              0               7000            

我想对VCR_VOUCHER_TYPE中的AIN和ACN分别求和，并在两列中显示.帮助我

I want to sum the amount separately for AIN and ACN in VCR_VOUCHER_TYPE and show it in two columns..Help me

推荐答案

您的列数是否固定?您的优惠券类型将始终为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

这篇关于如何将一列值显示为两列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！