Nested If Employee

Post date: 01-Jun-2015 15:43:40

Reference: http://forgetcode.com/Informatica/1059-Nested-If

Nested If condition can be performed using nested IIF statements or Decode function,

Example : Calculate Grade for the give marks, using nested IIF

1. IIF(MARKS>=90,'A',

2. (IIF(MARKS>= 75,'B',

3. (IIF(MARKS>=65,'C',

4. (IIF(MARKS>=55,'D',

5. IIF(MARKS>=45,'E',

6. 'F'))))))))

Example : Calculate Grade for the give marks, using Decode

1. DECODE(TRUE,

2. MARKS>=90,'A',

3. MARKS>=75,'B',

4. MARKS>=65,'C',

5. MARKS>=55,'D',

6. MARKS>=45,'E',

7. 'F')