oracle 報錶帶小計合計

標籤：ping   cas   ges   null   src   else   from   img   rom   

select
case when (grouping(glbm)=1) then ‘合計‘ else DECODE(glbm,null,‘‘,glbm) end glbm,
case when (grouping(hpzl)=1) then ‘‘ else DECODE(hpzl,null,‘‘,hpzl) end hpzl,
case when (grouping(syxz)=1 and grouping(hpzl)=0) then ‘小計‘ else DECODE(syxz,null,‘‘,syxz) end as syxz,
count(*)
from VEHICLEBA
where hpzl in (‘01‘,‘02‘,‘15‘) and (ywlx=‘登記‘ or ywlx=‘轉出中‘)
group by rollup(glbm,hpzl,syxz)

 

oracle 報錶帶小計合計