Dublettencheck über mehrere Spalten?

[Bummi]

Code:

Select Name,Vorname,Strasse,Count(*) 
from tabelle
Group by Name,Vorname,Strasse
Having Count(*)>1

gegf. mit Soundex o.ä.
sorry not sorgfältig genug gelesen

Code:

Select * from Adressen t
join (
Select Name,Vorname,Strasse,Count(*) as Anz
from Adressen
Group by Name,Vorname,Strasse
Having Count(*)>1
) a
on a.Name=t.Name and a.Vorname=t.Vorname and a.Strasse=t.Strasse
order by t.name,t.Vorname,t.Strasse