cwbb_zcfzb0表中有一个字段type,其中type的取值也许是如下几个:
type='负债类'
type='资产类'
type='权益类'
...如果type='负债类' or type='资产类'
那么我想实现
select max(kemudm) as kemudm,sum(jiefang_ncs-daifang_ncs) as ncs,sum(jiefang_qms-daifang_qms) as qms into cwbb_zcfzb from cwbb_zcfzb0 group by substring(kemudm,1,4)如果type='权益类'
那么我想实现
select max(kemudm) as kemudm,sum(daifang_ncs-jiefang_ncs) as ncs,sum(daifang_qms-jiefang_qms) as qms into cwbb_zcfzb from cwbb_zcfzb0 group by substring(kemudm,1,4)
如何将两句并成一句写呀?
type='负债类'
type='资产类'
type='权益类'
...如果type='负债类' or type='资产类'
那么我想实现
select max(kemudm) as kemudm,sum(jiefang_ncs-daifang_ncs) as ncs,sum(jiefang_qms-daifang_qms) as qms into cwbb_zcfzb from cwbb_zcfzb0 group by substring(kemudm,1,4)如果type='权益类'
那么我想实现
select max(kemudm) as kemudm,sum(daifang_ncs-jiefang_ncs) as ncs,sum(daifang_qms-jiefang_qms) as qms into cwbb_zcfzb from cwbb_zcfzb0 group by substring(kemudm,1,4)
如何将两句并成一句写呀?
from
(select max(kemudm) as kemudm,sum(jiefang_ncs-daifang_ncs) as ncs,sum(jiefang_qms-daifang_qms) as qms from cwbb_zcfzb0
Where type='负债类' or type='资产类'
group by substring(kemudm,1,4)
Union All
select max(kemudm) as kemudm,sum(daifang_ncs-jiefang_ncs) as ncs,sum(daifang_qms-jiefang_qms) as qms from cwbb_zcfzb0
Where type='权益类'
group by substring(kemudm,1,4)) A