Hi Garry
Perhaps following will help you (asuming that "id" is your soon-to-be
primary key):
select oid, id from tab a where exists
(select oid from tab b where b.id=a.id and b.oid<>a.oid)
order by id
Sincerely yours, Yury.
don.web-page.net, ICQ 11831432
Gary Hoffman wrote:
>
> Somehow, I've managed to get duplicate entries in my soon-to-be primary
> key field. How can I select for duplicates in a field? I know how to
> select for blank and NULL, but duplicates escape me.
>
> Thanks,
> Gary
