WITH T AS (
SELECT 'V' STATUS,41 SHULIANG FROM DUAL UNION ALL
SELECT 'C' STATUS,699 SHULIANG FROM DUAL UNION ALL
SELECT 'D' STATUS,19 SHULIANG FROM DUAL UNION ALL
SELECT 'J' STATUS,172 SHULIANG FROM DUAL)
SELECT T.*,SHULIANG/SUM(SHULIANG) OVER()*100 "百分百(实际值)",
ROUND(SHULIANG/SUM(SHULIANG) OVER()*100,2) "百分百(保留两位小数)" ,
RATIO_TO_REPORT(SHULIANG) over () FROM T ;
ORACLE百分百
最新推荐文章于 2021-04-11 18:38:41 发布