SQL语句中计算百分比 A.TOTAL_COUNT TOTALCOUNT,
A..QUES_COUNT QUESCOUNT,
CASE
WHEN TOTAL_COUNT = QUES_COUNT
THEN '100%'
ELSE TO_CHAR((ROUND(QUES_COUNT / DECODE(TOTAL_COUNT, 0, 1, TOTAL_COUNT), 4)
) * 100, 'fm9999990.00') || '%'
END QUESRATE
A..QUES_COUNT QUESCOUNT,
CASE
WHEN TOTAL_COUNT = QUES_COUNT
THEN '100%'
ELSE TO_CHAR((ROUND(QUES_COUNT / DECODE(TOTAL_COUNT, 0, 1, TOTAL_COUNT), 4)
) * 100, 'fm9999990.00') || '%'
END QUESRATE