sign(decode(GradeMode,'分值',(StandardPoint - amount*minuspoint),
'百分比',(StandardPoint * (1-amount*minuspoint/100)) ),1,
decode(GradeMode,'分值',(StandardPoint - amount*minuspoint),
'百分比',(StandardPoint * (1-amount*minuspoint/100)) ) ,0)
'百分比',(StandardPoint * (1-amount*minuspoint/100)) ),1,
decode(GradeMode,'分值',(StandardPoint - amount*minuspoint),
'百分比',(StandardPoint * (1-amount*minuspoint/100)) ) ,0)
decode(sign(decode(GradeMode,'分值',(StandardPoint - amount*minuspoint),
'百分比',(StandardPoint * (1-amount*minuspoint/100)) )),-1,0,decode(GradeMode,'分值',(StandardPoint - amount*minuspoint),
'百分比',(StandardPoint * (1-amount*minuspoint/100)) ))
as GainPoint
from ......