How to rewrite the following nested IFF statement to oracle Case when statement .
IIF(IN_RNK = 1,
IIF(IN_SUM > 2,IIF(IN_MTR_COVERAGE_NUMBER_A = 'A','ORIGINAL BASE','ORIGINAL RIDER'),IN_MTR_COVERAGE_NUMBER_A),
IN_MTR_COVERAGE_NUMBER_A)
You need to sign in to view this answers