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
http://www.sashanet.com
Thread
Finding DupsWayne Spivak8 Aug
  • Re: Finding DupsSasha Pachev9 Aug