Re: Finding duplicate rows in a table

chris <x_at_worldnet.att.net> wrote in article <34142F08.768F_at_worldnet.att.net>...
> I don't know how, but when I try and copy one of my tables to another
> server across the net, I get a constraint violation on the primary key.
> How can I find the rows in the original table that have duplicate
> primary key information (the primay key consists of two columns).
>

SELECT
  primary_key, count(*)
FROM foo
GROUP BY primary_key
HAVING count(*) > 1

regards,
Billy Received on Tue Sep 09 1997 - 00:00:00 CDT