List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:August 9 1999 5:50am
Subject:Re: Finding Dups
View as plain text  
Wayne Spivak wrote:
> I have a database that three fields, two are index - non-unique.  The third
> field if indexed would also be non-unique.
> I need to find a quick way to identify dups and decide whether or not to
> delete them.
> Is there a better way then a select statement ordered by....?
> Thanks

select *, count(*) as n from the_table group by dup_key having n > 1;

Sasha Pachev
Finding DupsWayne Spivak8 Aug
  • Re: Finding DupsSasha Pachev9 Aug