drop table grStrassenDbl;

create table grStrassenDbl as 
select max(idnr) as idnr   from grStrassen
group by PLZ, Strasse
having count(*) > 1;

delete from grStrassen where idnr in 
(select idnr  from grStrassenDbl);