'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'''這個(gè)查出來(lái)是一個(gè)值
以下是關(guān)于sql語(yǔ)句的問(wèn)題，求詳細(xì)解釋 ！
繁星點(diǎn)點(diǎn)滴滴
2021-06-30 11:07:32