SELECT DISTINCT SUM(T2.DEBIT) AS CUMUL_DEBIT, SUM(T2.CREDIT) AS CUMUL_CREDIT, T1.C_DATE FROM COMPTE AS T1, COMPTE AS T2 WHERE T1.C_DATE = (SELECT MAX(C_DATE) FROM COMPTE WHERE MONTH(C_DATE)=MONTH(T1.C_DATE) ) AND MONTH(T1.C_DATE)=MONTH(T2.C_DATE) AND YEAR(T1.C_DATE)=YEAR(T2.C_DATE) GROUP BY T1.C_DATE;
SELECT SUM(DEBIT) AS CUMUL_DEBIT, SUM(CREDIT) AS CUMUL_CREDIT FROM COMPTE
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT SUM(T2.DEBIT) AS CUMUL_DEBIT , SUM(T2.CREDIT) AS CUMUL_CREDIT, T1.C_DATE, T1.DEBIT, T1.CREDIT FROM COMPTE T1 ,COMPTE T2 WHERE T2.C_DATE <= T1.C_Date GROUP BY T1.C_DATE , T1.CREDIT , T1.DEBIT;