select JIHZT,SHUNX,GUIGMC,BANB,TIME,BANC,JIHL, SHIJL ,LEIX,SE,GUIGDM from table
UNION
select '','','','',to_date('','yyyy-mm-dd HH24:MI:SS'),'合计',sum(JIHL), sum(SHIJL),'','','' from tabel
oracle 求和后展示表中所有字段
最新推荐文章于 2024-07-25 07:07:02 发布
select JIHZT,SHUNX,GUIGMC,BANB,TIME,BANC,JIHL, SHIJL ,LEIX,SE,GUIGDM from table
UNION
select '','','','',to_date('','yyyy-mm-dd HH24:MI:SS'),'合计',sum(JIHL), sum(SHIJL),'','','' from tabel