Select TOTAL,DEDUCTION , d.DTYPE from (select SUM(AMOUNT) as "TOTAL",DEDUCTION from contribution c
WHERE TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'YYYY')) = 2020
-- AND UPPER(MISSIONARY_ID) = 'A02'
GROUP BY DEDUCTION )
INNER JOIN DEDUCTION_TYPE d
ON d.DTID = DEDUCTION
ORDER BY DEDUCTION
Select TOTAL,DEDUCTION , d.DTYPE, d.DTPERCENT from (select SUM(AMOUNT) as "TOTAL",DEDUCTION from contribution c
WHERE TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'YYYY')) = 2020
AND TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'MM')) = 2
-- AND UPPER(MISSIONARY_ID) = 'A02'
GROUP BY DEDUCTION )
INNER JOIN DEDUCTION_TYPE d
ON d.DTID = DEDUCTION
ORDER BY DEDUCTION
| No. | Subject |
|---|---|
| Notice | Certification Oracle SQL Developer |
| 154 | TECH on the Net |
| 153 | trim(to_char(:P113_REGULAR,'999G999G999G999G990D00')) |
| 152 | PIVOT |
| 151 | TEST 2 |
| 150 | CREATION DEDUCTION TYPE |
| 149 | PL/SQL for creation Tables |
| 148 | TEST 1 |
| » | INNER JOIN & GROUP BY |
| 146 | DISPLAY ONLY FEW ROWS |
| 145 | GROUP BY (for CHART) |
| 144 | INNER JOIN |
| 143 | LOOP - 2 |
| 142 | DATE Compare & Convert |
| 141 | LOOP & ROWNUM |
| 140 | Oracle Number Format |
| 139 | Page Reload in APEX |
| 138 | SUM / GROUP BY |
| 137 | MEDWIGS DB |
| 136 | HOW TO CONVERT DD/MM/YYYY -> MM/DD/YYYY |
| 135 | Attributes - Link Icon |
