select 目标字段1,目标字段2,
sum(bb.cydw)cydw,sum(bb.ybs)ybs,sum(bb.jcxx)jcxx,sum(bb.sgs)sgs,sum(bb.lhcj)lhcj,sum(bb.qt)qt,sum(nvl(bb.jcxx,0)+nvl(bb.sgs,0)+nvl(bb.lhcj,0)+nvl(bb.qt,0))total,round(avg(bb.timeliness),2)timeliness,round(avg(bb.rate),2)rate
from 目标表
bb group by rollup(目标字段1,目标字段2)
oracle 合计
最新推荐文章于 2023-09-04 16:58:26 发布