摘要:
select*,casewhenresultrate>0thencase--<<case嵌套whenOdds>0thenOdds*ResultRate --如果resultrate大于零,且odds大于零,返回结果whenOdds<0thenResultRate --如果resultrate大于零,且odds小于零,返回结果end-->>case嵌套whenresultrate<0thencase--<<case嵌套whenOdds>0thenResultRate --如果resultrate小于零,且odds大于零,返回Res 阅读全文