select
case a.c_trans_fee_mode
when '2' then
case a.c_trans_sqfee_mode when '2' then abs(a.f_amount + a.f_trans_fee - f_trans_sqfee) else abs(a.f_amount + a.f_trans_fee ) end
else
case a.c_trans_sqfee_mode when '2' then abs(a.f_amount - f_trans_sqfee) else abs(a.f_amount) end
end f_hfamt,abs(a.f_amount) f_amount0
from atself_investno a