1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| CREATE OR REPLACE VIEW V_SYNTHESE_3
(CEN_CIB, RSN_ID_RSE, RUPTURE, M12, M11,
M10, M9, M8, M7, M6,
M5, M4, M3, M2, M1,
M, TOP)
AS
select "CEN_CIB","RSN_ID_RSE", "RUPTURE", "M12", "M11", "M10", "M9", "M8", "M7", "M6",
"M5", "M4", "M3", "M2", "M1", "M", "TOP"
FROM
v_synthese_3c
UNION
select distinct NULL, null,'11' rupture,
sum(M12) M12,sum(M11) M11,sum(M10) M10,sum(M9) M9,sum(M8) M8,
sum(M7) M7,sum(M6) M6,sum(M5) M5,sum(M4) M4,sum(M3) M3,sum(M2) M2,sum(M1) M1,sum(M) M,
to_number('1') top
from v_synthese_3c
group by M12
ORDER BY RUPTURE, CEN_CIB, RSN_ID_RSE,Top
/ |
