ORACLE百分百

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 ;