1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| SELECT t1.centrerc, t1.registrecommerce, t1.annee, t1.codegu,
t1.som_gu,
100 * t1.som_gu / t2.som-tot AS pourcentage
FROM (
SELECT s1.centrerc, s1.registrecommerce, s1.annee, s1.codegu,
sum(s1.valeurarticle) AS som_gu
FROM source_dum s1
GROUP BY s1.centrerc, s1.registrecommerce, s1.annee, s1.codegu
) AS t1
INNER JOIN (
SELECT s2.centrerc, s2.registrecommerce, s2.annee,
sum(s2.valeurarticle) AS som_tot
FROM source_dum s2
GROUP BY s2.centrerc, s2.registrecommerce, s2.annee
) AS t2 ON t1.centrerc = t2.centrerc
AND t1.registrecommerce = t2.registrecommerce
AND t1.annee = t2.annee
ORDER BY t1.centrerc, t1.registrecommerce, t1.annee, t1.codegu |
Partager