'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'''這個查出來是一個值
以下是關于sql語句的問題,求詳細解釋 !
繁星點點滴滴
2021-06-30 11:07:32