Re: identical columns

From: José Nicolau <jnicolau_at_hotmail.com>
Date: Thu, 10 Sep 1998 23:27:07 +0200
Message-ID: <35F8442A.4BFDCE96@hotmail.com>

Try this

select *
  from table t1
  where exists (select 0
    from table t2
    where t2.columns_with_duplicates = t1.columns_with_duplicates       and t2.rowid != t1.rowid)

You may use 'select distinct *...'

Corinna Becker wrote:

> Hello,
> I have the following problem: I have a table of which I know that it
> contains duplicate rows. I want to find all rows that are duplicate.
> How can I do that?
> Regards and thanks
> Corinna Becker
Received on Thu Sep 10 1998 - 16:27:07 CDT