Am Donnerstag, 22. August 2002 01:52 schrieb Johnson, Shaunn:
> Howdy:
>
> I have a table that has a primary key on it. Somewhere in
> the table, it seems to have a few duplicate records in it.
> I'm trying to weed out the duplicates, but am having problems
> with the sql.
>
...
Hi,
select distinct t1.name, t1.addr1, t1.phone, t1.city
from emp_table t1
where (select count(*) from emp_table t2
where t1.name = t2.name
and t1.addr1 = t2.addr1
and t1.phone = t2.phone
and t1.city = t2.city) > 1
will do it.
Tommi
