Select d.DTYPE,d.DTPERCENT,JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC,

(NVL(JAN,0) + NVL(FEB,0) + NVL(MAR,0) + NVL(APR,0) + NVL(MAY,0) + NVL(JUN,0) 

 + NVL(JUL,0) + NVL(AUG,0) + NVL(SEP,0) + NVL(OCT,0) + NVL(NOV,0) + NVL(DEC,0)) as "TOTAL" from DEDUCTION_YEAR_MI

INNER JOIN DEDUCTION_TYPE d

ON d.DTID = DTYPEID

Order by DTYPEID

 

 

 

 

 

 

Select d.DTYPE,d.DTPERCENT,JAN*d.DTPERCENT/100 as "JAN",FEB*d.DTPERCENT/100 as "FEB",

MAR*d.DTPERCENT/100 as "MAR",APR*d.DTPERCENT/100 as "APR" ,MAY*d.DTPERCENT/100 as "MAY",

JUN*d.DTPERCENT/100 as "JUN",JUL*d.DTPERCENT/100 as "JUL" ,AUG*d.DTPERCENT/100 as "AUG" ,SEP*d.DTPERCENT/100 as "SEP",

OCT*d.DTPERCENT/100 as "OCT",NOV*d.DTPERCENT/100 as "NOV" ,DEC*d.DTPERCENT/100 as "DEC" 

,(NVL(JAN,0)*d.DTPERCENT/100 + NVL(FEB,0)*d.DTPERCENT/100 + NVL(MAR,0)*d.DTPERCENT/100 

+ NVL(APR,0)*d.DTPERCENT/100 + NVL(MAY,0)*d.DTPERCENT/100 + NVL(JUN,0)*d.DTPERCENT/100 

+ NVL(JUL,0)*d.DTPERCENT/100 + NVL(AUG,0)*d.DTPERCENT/100 + NVL(SEP,0)*d.DTPERCENT/100

+ NVL(OCT,0)*d.DTPERCENT/100 + NVL(NOV,0)*d.DTPERCENT/100 + NVL(DEC,0)*d.DTPERCENT/100) as "TOTAL"

from DEDUCTION_YEAR_MI

INNER JOIN DEDUCTION_TYPE d

ON d.DTID = DTYPEID

Order by DTYPEID