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
|
WITH MaTable AS
(
SELECT 'Categ 1' AS Categ, 'Article 1' as Lib,1 AS Qte FROM DUAL UNION ALL
SELECT 'Categ 1' , 'Article 2' , 2 FROM DUAL UNION ALL
SELECT 'Categ 2' , 'Article 3' , 5 FROM DUAL UNION ALL
SELECT 'Categ 3' , 'Article 4' , 20 FROM DUAL UNION ALL
SELECT 'Categ 3' , 'Article 5' , 29 FROM DUAL UNION ALL
SELECT 'Categ 2' , 'Article 6' , 40 FROM DUAL
)
SELECT
Categ,lib,
sum (Qte) AS Qte
FROM MaTable
GROUP BY grouping sets(categ,Lib,null)
order by Categ,Lib
CATEG LIB QTE
------- --------- ---
Categ 1 3
Categ 2 45
Categ 3 49
Article 1 1
Article 2 2
Article 3 5
Article 4 20
Article 5 29
Article 6 40
97 |
Partager