SQL-Abfrage Duplikate suchen

[Sonic]

select distinct a.id, a.name from $tabelle as a, $tabelle as b where a.name = b.name and a.id <> b.id order by name, id;

An deiner Idee scheint was dran zu sein. Muss noch mal testen. Danke