暫存的資料統計方法說明

select nvl(dw,'全部單位')dw,nvl(sfxmmc,'收費合計')sfxmmc, je from
(
select getdwbyxh(zbid) dw,sfxmmc,sum(sfje) je from fs_czsfmxb where getdwbyxh(zbid) is not null group by rollup(getdwbyxh(zbid),sfxmmc)
)
select nvl(getdwbyxh(zbid),'全部單位') dw,nvl(sfxmmc,'收費合計') sfxmmc,sum(sfje) je from fs_czsfmxb where getdwbyxh(zbid) is not null group by rollup(getdwbyxh(zbid),sfxmmc)
select nvl(sfxmmc,'收費合計')sfxmmc,nvl(dw,'全部單位')dw, je from
(
select sfxmmc, getdwbyxh(zbid) dw,sum(sfje) je from fs_czsfmxb where getdwbyxh(zbid) is not null group by rollup(sfxmmc,getdwbyxh(zbid))
)
select nvl(sfxmmc,'收費合計') sfxmmc, nvl(getdwbyxh(zbid),'全部單位') dw,sum(sfje) je from fs_czsfmxb where getdwbyxh(zbid) is not null group by rollup(sfxmmc,getdwbyxh(zbid))[@more@]