分组求和后再求总量

sum() over ( ) ratio_to_report () over ( ) SELECT b.zdmc,SUM(CZE/100) as je,sum(SUM(CZE/100)) over ( ) AS ttje FROM T_YKT_REC_CONSUME c left join SJZX.T_YKT_BASE_TERM b on c.ZDBH=b.ZDBH INNER JOIN SJZX.T_BZKS s on s.XH = c.XGH AND to_date(s.SJBYSJ,‘yyyy-MM-dd HH24:mi:ss’)>sysdate GROUP BY b.zdmc ORDER BY je desc