'select case when (select nvl(sum(case factorcode when ''D001'' then factorvalue end),0) from llotherfactor where feeitemtype=''D'' and clmno=''?CaseNo?'')>0 then least(?je_gf?,?je_gf?+(select nvl(sum(case factorcode when ''D002'' then factorvalue end),0)from llotherfactor where feeitemtype=''D'' and clmno=''?CaseNo?''), ?amnt?-?compensatedutysumpay?) else least((?je_gf?+(select nvl(sum(case factorcode when ''D002'' then factorvalue end),0) from llotherfactor where feeitemtype=''D'' and clmno=''?CaseNo?''))*0.8,?je_gf?,?amnt?-?compensatedutysumpay?) end from ldsysvar where sysvar = ''onerow'''这个查出来是一个值
添加回答
举报
0/150
提交
取消