1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
with ma_table as
(
select 1 id, 1 client_id, 1 age_du_capitaine from dual union all
select 2, 1, 1 from dual union all
select 3, 2, 1 from dual union all
select 4, 3, 1 from dual union all
select 5, 3, 1 from dual union all
select 6, 3, 2 from dual union all
select 7, 4, 1 from dual union all
select 8, 4, 2 from dual union all
select 9, 4, 2 from dual union all
select 10, 5, 1 from dual union all
select 11, 5, 1 from dual
)
select count(*) from (
select distinct client_id, age_du_capitaine
from ma_table
); |
Partager