update i_ks_clinical_work set RATE_GOOD_NUM_WORK = round(((CURE_NUM_WORK+GOOD_NUM_WORK)/PATIENTS_NUM_WORK * 10000)/100,2) where PATIENTS_NUM_WORK is not null;
还有可能用到非空判断NVL(CURE_NUM_WORK,0),NVL(GOOD_NUM_WORK,0)
trunc()不四舍五入,round()四舍五入,%由jsp页面固定
update i_ks_clinical_work set RATE_GOOD_NUM_WORK = round(((CURE_NUM_WORK+GOOD_NUM_WORK)/PATIENTS_NUM_WORK * 10000)/100,2) where PATIENTS_NUM_WORK is not null;
还有可能用到非空判断NVL(CURE_NUM_WORK,0),NVL(GOOD_NUM_WORK,0)
trunc()不四舍五入,round()四舍五入,%由jsp页面固定