select t.year,
t.季度 时间类型,
sum(A)over (order by rownum rows BETWEEN unbounded preceding and current row)A,
sum(B)over (order by rownum rows BETWEEN unbounded preceding and current row)B,
sum(C)
over (order by rownum rows BETWEEN
unbounded preceding and current row)
C ,
sum(D)
over (order by rownum
rows BETWEEN unbounded preceding and current row)
D ,
sum(升级)
over (order
by rownum rows BETWEEN unbounded preceding and current row)
升级 ,
sum(降级)
over (order by rownum rows BETWEEN unbounded preceding and
current row)
降级,
sum(正常受理)
over (order by rownum rows BETWEEN unbounded
preceding and current row)
正常受理 ,
sum(正常办结)
over (order by rownum rows
BETWEEN unbounded preceding and current row)
正常办结,
sum(挽回经济损失)
over (order by rownum rows BETWEEN unbounded preceding and current
row)
挽回经济损失,
sum(工商)over (order by rownum rows BETWEEN unbounded preceding and current row)工商,
sum(质监)over (order by rownum rows BETWEEN unbounded preceding and current row)质监,
sum(食药监)over (order by rownum rows BETWEEN unbounded preceding and current row)食药监,
sum(物价)over (order by rownum rows BETWEEN unbounded preceding and current row)物价
from (
select
t.year ,
t.季度,
sum(decode(t.F_CREDIT_LEVEL, 'A', t.NUM , 0)) "A",
sum(decode(t.F_CREDIT_LEVEL, 'B', t.NUM , 0)) "B",
sum(decode(t.F_CREDIT_LEVEL, 'C', t.NUM , 0)) "C",
sum(decode(t.F_CREDIT_LEVEL, 'D', t.NUM , 0)) "D",
sum(decode(t.F_CREDIT_LEVEL, '升级', t.NUM , 0)) "升级",
sum(decode(t.F_CREDIT_LEVEL, '降级', t.NUM , 0)) "降级",
sum(decode(t.F_CREDIT_LEVEL, '已受理', t.NUM , 0)) "正常受理",
sum(decode(t.F_CREDIT_LEVEL, '已办结', t.NUM , 0))"正常办结",
sum(decode(t.F_CREDIT_LEVEL, '挽回经济损失', t.NUM , 0)) "挽回经济损失",
sum(decode(t.F_CREDIT_LEVEL, '工商', t.NUM , 0)) "工商",
sum(decode(t.F_CREDIT_LEVEL, '质监', t.NUM , 0)) "质监",
sum(decode(t.F_CREDIT_LEVEL, '食药监', t.NUM ,
t.季度 时间类型,
sum(A)over (order by rownum rows BETWEEN unbounded preceding and current row)A,
sum(B)over (order by rownum rows BETWEEN unbounded preceding and current row)B,
sum(C)
over (order by rownum rows BETWEEN
unbounded preceding and current row)
C ,
sum(D)
over (order by rownum
rows BETWEEN unbounded preceding and current row)
D ,
sum(升级)
over (order
by rownum rows BETWEEN unbounded preceding and current row)
升级 ,
sum(降级)
over (order by rownum rows BETWEEN unbounded preceding and
current row)
降级,
sum(正常受理)
over (order by rownum rows BETWEEN unbounded
preceding and current row)
正常受理 ,
sum(正常办结)
over (order by rownum rows
BETWEEN unbounded preceding and current row)
正常办结,
sum(挽回经济损失)
over (order by rownum rows BETWEEN unbounded preceding and current
row)
挽回经济损失,
sum(工商)over (order by rownum rows BETWEEN unbounded preceding and current row)工商,
sum(质监)over (order by rownum rows BETWEEN unbounded preceding and current row)质监,
sum(食药监)over (order by rownum rows BETWEEN unbounded preceding and current row)食药监,
sum(物价)over (order by rownum rows BETWEEN unbounded preceding and current row)物价
from (
select
t.year ,
t.季度,
sum(decode(t.F_CREDIT_LEVEL, 'A', t.NUM , 0)) "A",
sum(decode(t.F_CREDIT_LEVEL, 'B', t.NUM , 0)) "B",
sum(decode(t.F_CREDIT_LEVEL, 'C', t.NUM , 0)) "C",
sum(decode(t.F_CREDIT_LEVEL, 'D', t.NUM , 0)) "D",
sum(decode(t.F_CREDIT_LEVEL, '升级', t.NUM , 0)) "升级",
sum(decode(t.F_CREDIT_LEVEL, '降级', t.NUM , 0)) "降级",
sum(decode(t.F_CREDIT_LEVEL, '已受理', t.NUM , 0)) "正常受理",
sum(decode(t.F_CREDIT_LEVEL, '已办结', t.NUM , 0))"正常办结",
sum(decode(t.F_CREDIT_LEVEL, '挽回经济损失', t.NUM , 0)) "挽回经济损失",
sum(decode(t.F_CREDIT_LEVEL, '工商', t.NUM , 0)) "工商",
sum(decode(t.F_CREDIT_LEVEL, '质监', t.NUM , 0)) "质监",
sum(decode(t.F_CREDIT_LEVEL, '食药监', t.NUM ,