1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
SELECT
D.madate,
sum(decode(F.numfac,null,0,1) as nbfactemises,
sum(decode(F.valfac,null,0,valregle,1,0) as nbfactreglees,
sum(decode(F.valfac,null,0,decode(F.valregle,null,1,0)) as nbfactimpayees
FROM facture F,
(select to_date('datechoisie','dd/mm/yyyy') madate FROM dual) D
WHERE D.madate = F.datefac(+)
UNION
D.madate,
sum(decode(F.numfac,null,0,1) as nbfactemises,
sum(decode(F.valfac,null,0,valregle,1,0) as nbfactreglees,
sum(decode(F.valfac,null,0,decode(F.valregle,null,1,0)) as nbfactimpayees
FROM facture F,
(select add_months(to_date('datechoisie','dd/mm/yyyy'),-1) madate FROM dual) D
WHERE D.madate = F.datefac(+)
UNION
D.madate,
sum(decode(F.numfac,null,0,1) as nbfactemises,
sum(decode(F.valfac,null,0,valregle,1,0) as nbfactreglees,
sum(decode(F.valfac,null,0,decode(F.valregle,null,1,0)) as nbfactimpayees
FROM facture F,
(select add_months(to_date('datechoisie','dd/mm/yyyy'),-2) madate FROM dual) D
WHERE D.madate = F.datefac(+) |
Partager