SELECT ZWKMYE_KJND as 年度,ZWKMYE_KJQJ as 月份,ZWKMYE_DWBH as 单位,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 税金,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_DFFS end) 其他业务收入,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 其他业务支出    ,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 营业费用,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 管理费用,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 财务费用,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_DFFS end) 投资收益,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_DFFS end) 营业外收入,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 营业支出,

sum(case ZWKMYE_KMBH when '' then 0-ZWKMYE_DQYE end) 累计折旧,

sum(case ZWKMYE_KMBH when '' then 0-ZWKMYE_DQYE end) 累计摊销,

sum(case ZWKMYE_KMBH when '' then ZWKMYE_JFFS end) 利息支出

from  VW_GLBI_CWFX_JLR_KMYE

where 1=1

and ZWKMYE_KMBH in ('','','','','','','','','','','','')

and ZWKMYE_DWBH=''

and ZWKMYE_KJND=''

group by ZWKMYE_KJND,ZWKMYE_KJQJ,ZWKMYE_DWBH

create table zy

(

    F01 varchar(4),

    F02 int

)

insert into zy

select 'A',10

union all

select 'B',10

union all

select 'C',10

union all

select 'D',10

union all

select 'E',10

select

sum(case F01 when 'A' then F02 end) A,

sum(case F01 when 'B' then F02 end) B

from zy