Re: Finding Dups

[Sasha Pachev]

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