1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SQL> with t (n1,n2,n3,numseq,categorie) as (
2 select 10,0,0,1,'A' from dual union all
3 select 10,0,0,2,'A' from dual union all
4 select 10,0,0,3,'A' from dual union all
5 select 10,0,0,1,'B' from dual union all
6 select 10,0,0,2,'B' from dual union all
7 select 10,0,0,3,'' from dual union all
8 select 10,25,0,1,'A' from dual union all
9 select 10,25,0,2,'A' from dual union all
10 select 10,25,0,1,'B' from dual union all
11 select 10,25,0,2,'B' from dual
12 )
13 select n1,n2,n3,
14 count(*), count(categorie), count(distinct categorie), count(distinct coalesce(categorie,'XXX'))
15 from t
16 group by n1,n2,n3
17 /
N1 N2 N3 COUNT(*) COUNT(CATEGORIE) COUNT(DISTINCTCATEGORIE) COUNT(DISTINCTCOALESCE(CATEGORIE,'XXX'))
---------- ---------- ---------- ---------- ---------------- ------------------------ ----------------------------------------
10 0 0 6 5 2 3
10 25 0 4 4 2 2
SQL> |
Partager