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 35 36 37 38 39 40 41
|
SELECT
sum(nvl(a0,0)) "A0",
sum(nvl(a1,0)) "A1",
sum(nvl(a2,0)) "A2",
sum(nvl(a3,0)) "A3",
sum(nvl(a4,0)) "A4",
sum(nvl(a5,0)) "A5",
sum(nvl(a6,0)) "A6",
sum(nvl(autoa0,0)) "Auto A0",
sum(nvl(autoa1,0)) "Auto A1",
sum(nvl(autoa2,0)) "Auto A2",
sum(nvl(autoa3,0)) "Auto A3",
sum(nvl(autoa4,0)) "Auto A4",
sum(nvl(autoa5,0)) "Auto A5",
sum(nvl(autoa6,0)) "Auto A6",
sum(nvl(b0,0)) "B0",
sum(nvl(b1,0)) "B1",
sum(nvl(b2,0)) "B2",
sum(nvl(b3,0)) "B3",
sum(nvl(b4,0)) "B4",
sum(nvl(b5,0)) "B5",
sum(nvl(b6,0)) "B6",
sum(nvl(autob0,0)) "Auto B0",
sum(nvl(autob1,0)) "Auto B1",
sum(nvl(autob2,0)) "Auto B2",
sum(nvl(autob3,0)) "Auto B3",
sum(nvl(autob4,0)) "Auto B4",
sum(nvl(autob5,0)) "Auto B5",
sum(nvl(autob6,0)) "Auto B6",
sum(recette) "Recette",
sum(cap_a) "Cap A",
sum(cap_b) "Cap B",
type_outil "Type outil",
sum(traf_a + traf_b) "Trafic total",
niveau "Niveau"
FROM
base_outils |
Partager