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 26 27 28 29 30 31 32 33 34
| SELECT m.idmois,
m.moi,
MONTHNAME(c.datedec)AS Mois,
MONTH(c.datedec)AS nummois,
YEAR(c.datedec) AS Année,
COALESCE(SUM(c.m), 0) AS m,
COALESCE(SUM(c.f), 0) AS f,
COALESCE(SUM(c.m1), 0) AS m1,
COALESCE(SUM(c.f1), 0) AS f1,
COALESCE(SUM(c.m2), 0) AS m2,
COALESCE(SUM(c.f2), 0) AS f2,
COALESCE(SUM(c.m3), 0) AS m3,
COALESCE(SUM(c.f3), 0) AS f3,
COALESCE(SUM(c.m4), 0) AS m4,
COALESCE(SUM(c.f4), 0) AS f4,
COALESCE(SUM(c.m5), 0) AS m5,
COALESCE(SUM(c.f5), 0) AS f5,
COALESCE(SUM(c.m6), 0) AS m6,
COALESCE(SUM(c.f6), 0) AS f6,
COALESCE(SUM(c.m7), 0) AS m7,
COALESCE(SUM(c.f7), 0) AS f7,
COALESCE(SUM(c.m8), 0) AS m8,
COALESCE(SUM(c.f8), 0) AS f8,
COALESCE((sum(c.m) + sum(c.m1) + sum(c.m2) + sum(c.m3) + sum(c.m4) + sum(c.m5) + sum(c.m6) + sum(c.m7) + sum(c.m8)), 0) AS Total_M,
COALESCE((sum(c.f) + sum(c.f1) + sum(c.f2) + sum(c.f3) + sum(c.f4) + sum(c.f5) + sum(c.f6) + sum(c.f7) + sum(c.f8)), 0) AS Total_F,
COALESCE((sum(c.m) + sum(c.m1) + sum(c.m2) + sum(c.m3) + sum(c.m4) + sum(c.m5) + sum(c.m6) + sum(c.m7) + sum(c.m8)
+ sum(c.f) + sum(c.f1) + sum(c.f2) + sum(c.f3) + sum(c.f4) + sum(c.f5) + sum(c.f6) + sum(c.f7) + sum(c.f8)), 0) AS Total,
FROM conteneur c
RIGHT OUTER JOIN mois m ON MONTH(c.datedec) = m.idmois
GROUP BY YEAR(c.datedec),
MONTHNAME(c.datedec),
m.idmois,
MONTH(c.datedec)
ORDER BY m.idmois ASC |
Partager