
Zitat von
Reallo
unschoen, aber:
SELECT ad.adresse, (SELECT COUNT(*) FROM adresse WHERE adresse=ad.adresse) AS gesamt, COUNT(anschlussart) AS anz, 100/(SELECT COUNT(*) FROM adresse WHERE adresse=ad.adresse)::real*COUNT(ad.anschlussart):: real AS prozent, anschlussart FROM
adresse ad
GROUP BY ad.adresse, ad.anschlussart
Okay, ich biete:
Code:
select distinct adresse,
count(*) over (partition by adresse) as gesamt,
count(*) over (partition by adresse,anschlussart) as anz,
(100* count(*) over (partition by adresse,anschlussart)::numeric/count(*) over (partition by adresse))::numeric(5,2) as prozent,
anschlussart
from adresse
order by adresse,
anschlussart;
Andreas
Lesezeichen