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@]
(
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@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15247/viewspace-890031/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
