CREATE TABLE TEST01(VALUES1 VARCHAR2(10),VALUES2 VARCHAR2(10),VALUES3 VARCHAR2(10))
INSERT INTO TEST01 VALUES('1','2','3');
INSERT INTO TEST01 VALUES('1','2',' ');
INSERT INTO TEST01 VALUES('1',' ',' ');
INSERT INTO TEST01 VALUES(' ',' ','3');
INSERT INTO TEST01 VALUES(' ',' ',' ');
SELECT T1.VALUES1
,CASE WHEN T1.COUNT_DEPT=0 THEN '100%'
WHEN NVL(T1.VALUES1,' ')=' ' THEN '0'
ELSE TRUNC(1/T1.COUNT_DEPT,2)*100||'%' END RATIO1
,T1.VALUES2
,CASE WHEN T1.COUNT_DEPT=0 THEN '0'
WHEN NVL(T1.VALUES2,' ')=' ' THEN '0'
ELSE TRUNC(1/T1.COUNT_DEPT,2)*100||'%' END RATIO2
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)