A new column named "DED_LAYER_BENCHMARK_LP" is created from Excel IF function as shown below.
DED_LAYER_BENCHMARK_LP = =if(_DataCell_ULFBL<=_InputCell_Deductible,
_DataCell_Original_Bench_LP_r0000_c0000,0) +
if(_DataCell_ULFBL + _InputCell_Layer_r0000_c0000 <= _InputCell_Deductible,
_DataCell_Original_Bench_LP_r0001_c0000, 0)
I want write the above excel code in SQL code
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…