[PL\SQL] QUERY su stessa tabella e group by

[MacApp]

non ho provato, ma piu' o meno dovrebbe essere cosi':

select b.count_cc_f, b.CC_F, a.C_MATRICOLA
from CLIENTE as a
left join (select count(CC_F) count_cc_f, CC_F from CLIENTE group by CC_F) as b
on a.CC_F = b.CC_F

insomma fai una left join tra la tabella CLIENTE e la group by CC_F della stessa