1 rollup() 推荐
rollup()是group by的一个扩展函数,初步的感觉是,可以多个列进行group by,然后分别进行统计。
示例 (给group列加rollup)
select CENTNO,
count(name) 账户数,count(distinct type)类型,sum(yue) 余额
from table e
where to_char(e.jzdate,'yyyymmdd')='20200101'
group by rollup(CENTNO)
order by CENTNO asc
2 用union (缺点,脚本复杂时较长,效率稍低)
select AAA,BBBB from table union select '合计',' ',' ',sum(AAAA),sum(BBBB) from table;