select year, a, b, c, a+b+c from
(
select year,sum(decode(type,1,count,0)) a,sum(decode(type,2,count,0)) b,sum(decode(type,3,count,0)) c
from
(
select t.st_award_year year,t.St_Type type,count(*) count
from er_recognition_info t
where t.st_deleted = '0'
group by t.st_type,t.st_award_year
) t
group by year
order by year
)
列改行排列
最新推荐文章于 2024-07-23 15:38:58 发布