admin 2020.10.17 12:44 Views : 81
select DTID from DEDUCTION_TYPE
WHERE ACTIVE = 'A'
ORDER BY DTID
Select SUM(AMOUNT) from CONTRIBUTION
WHERE TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'YYYY')) = 2020
AND TO_NUMBER(TO_CHAR(CONTRIBUTION_DATE, 'MM')) = 1
AND DEDUCTION IS NULL